Convert Text to Date

ta5

Hi
Whats best to convert a string (yyyymmdd) to a date?
Btw: It works when I first prepare a new string to ddmmyyyy and then use the evaluate statement on the new string. But I'm not sure whether this works on all work stations (country settings...).

Thanks in advance
Thomas

ara3n

ddmmyyyy would not work in US. evaluate would inteperts it as mmddyyyy. and it would error and get the wrong date.

ta5

thanks!
so its better to use dmy2date?
thomas

kriki

ha5 wrote:

thanks!
so its better to use dmy2date?
thomas

Always better, because the other always depends on the regional settings of the PC.

ta5

thanks =D>

ara3n

welcome. :P