Page 1 of 1

Have function CTOD(^YYYYMMDD^,1)?

Posted: Wed Jul 21, 2010 7:48 pm
by Dutch
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

=> CTOD(^YYYYMMDD^,1)?

Posted: Thu Jul 22, 2010 7:55 pm
by kfleming
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