Format date in dateformat/parsedate

Classic Servoy
1

Hi,

I try to convert a datestring

utils.parseDate('Fri Feb 15 00:00:00:00 CET 2013','EEE MMM d HH:mm:ss z yyyy'))

This returns null

I found out that the problem is that ‘Fri’ is not recognized as a day in Dutch.
When I do the dateformat

utils.dateFormat(_today,'EEE MMM d HH:mm:ss z yyyy')

It returns a date in Dutch…

I tried to reset locale settings default to en,BE but it didn’t change anything…

Any help on this?
(This occurs in developer, didn’t test it on a server yet)

thanks

2

2 things I see on my end, I’m in a US locale so it might not be relevant :

1 - you’ve got a trailing parenthesis in your posted code. I realize you probably know that already.

2 - Your string has hours, minutes, seconds and milliseconds but your format doesn’t have milliseconds.

If I try to parse your string as such (note the :SS ) :

utils.parseDate('Fri Feb 15 00:00:00:00 CET 2013','EEE MMM dd HH:mm:ss:SS z yyyy')

outputs → Thu Feb 14 17:00:00 CST 2013