Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Support needed for converting date in text format to numeric

explorenowblog
Tera Contributor

"Dear fellow SAS users, firstly I hope to achieve the level to be able to help others but I am afraid that may take a while 🙂 I have a dataset with dates (Date_and_time_of_assessment) in Character format like this: 2023-01-26T07:00.

I want to convert these values into a numeric format so I can use them for calculation purposes.

I have tried SAMP_DT=INPUT(Date_and_time_of_assessment, anydtdtm16.); but that does not work. Could anyone help me, it is much appreciated. 

0 REPLIES 0