Convert Text to Date

ta5 · 2006-06-30

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 · 2006-06-30

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

ta5 · 2006-06-30

thanks!
so its better to use dmy2date?
thomas

kriki · 2006-06-30

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 · 2006-06-30

thanks =D>

ara3n · 2006-06-30

welcome. :P

Convert Text to Date

Answers

Categories