05-04-2015 03:49 PM
Hi all, I want to convert StartTime and EndTime which are character variable to datetime variable so I can do calculation. Please see our they are structured in my data source.
For example, the first row, I want my calculation to say that customer started at 11:00 AM and ended 11:00 AM. You are welcome to offer me another option of getting my desire calculation without any conversion.
Thank you ahead.
05-04-2015 04:31 PM
You can convert these type of text strings using the ANYDTDTM informat. Unfortunately it will not read the milliseconds. In the code below two methods are shown, one using the ANYDTDTM informat, the other uses a combination of two informats for the date and time part and then combine the date and seconds together using the DHMS function.