Converting MM/DD/YY date to DD/MM/YYYY in EE

[StuM]

Hi All,

I am trying to convert a character date, format:

MM/DD/YY

to a character date, format:

DD/MM/YYYY

In Server Edition, this was easily taken care of using oconv, but now tht we are moving onto EE, I am having difficulty. I tried the following:

DateToString(StringToDate(Trim(lkDatesStripped.DataOut), "%mm/%dd/%yy"), "%dd/%mm/%yyyy")

This however took input 05/11/06 and converted to 11/05/1906!

Any suggestions gratefully received.

Regards
StuM

[ArndW]

It seems that your settings for the $APT_DATE_CENTURY_BREAK_YEAR are such that this conversion works incorrectly. You can also specifically force a century for a 2 digit date by using %year_cutoffyy two digit year from year_cutoff (e.g. %2000yy)

[StuM]

It seems that your settings for the $APT_DATE_CENTURY_BREAK_YEAR are such that this conversion works incorrectly. You can also specifically force a century for a 2 digit date by using %year_cutoffy ...

Thanks very much for the info, I shall have a play and see how it goes.

Cheers
StuM

[StuM]

Thanks again - use of %year_cutoffyy achieved the desired result.

Could anyone tell me how this works. I am using %2000yy. What theoretically will happen in 2100?

Thanks in advance.
StuM

[Lotus26]

Thanks again - use of %year_cutoffyy achieved the desired result.

Could anyone tell me how this works. I am using %2000yy. What theoretically will happen in 2100?

Thanks in advance.
StuM

I think it works same. The behaviour will not change.

Rgds
Lotus

[kumar_s]

Four digit year which marks the century two-digit dates belong to. It is
set to 1900 by defult.
At 2100 $APT_DATE_CENTURY_BREAK_YEAR should be changed to 2100.

[StuM]

Great, thanks very much for your help.

Regards
StuM