Have function CTOD(^YYYYMMDD^,1)?

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Dutch
Posts: 57
Joined: Tue Oct 10, 2017 12:44 pm

Have function CTOD(^YYYYMMDD^,1)?

Post by Dutch » Wed Jul 21, 2010 7:48 pm

I would like to convert "YYYYMMDD" back to Date format for avoiding regional format problem. What is the function can do? I used V.10.____Thanks&Regards,__Dutch

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> CTOD(^YYYYMMDD^,1)?

Post by kfleming » Thu Jul 22, 2010 7:55 pm

CTOD needs a character string that is in the windows short date format that is saved in the report.__So you need to use some addition string functions to convert the YYYYMMDD into either MM/DD/YYYY or DD/MM/YYYY depending on the date format in the report.__No simper way to get there.____Kathleen__R&R Support

Post Reply