[RESOLVED] change date format

[raouleduke]

Does anyone know how to change 11841 to 1941-11-08. I have this date format coming out a old system that I need to change. Thanks in advance for any help.

[Piranha]

Basically it is impossible to decode all the dates in that format. As an example, what date is 11197? Is it year 1997, month 11, day 1 or is it year 1997, month 1, day 11?

But if you can solve that problem you should be able to use the [man]date[/man] function to create the date and the [man]substr[/man] function to get the values from the old date.

[raouleduke]

11197 would be 1997-01-11, and 110197 would be 1997-11-01, so how would I decode that.

[NogDog]

// assume $oldDate has the original value:
preg_match('/(\d{1,2})(\d\d)(\d\d)/', $oldDate, $dateParts);
$newDate = sprintf('%04d-%02d-%02d', $dateParts[3], $dateParts[1], $dateParts[2]);

[raouleduke]

That seems to work great, just missing one thing. The output comes out as 0048-01-23, when it should be 1948-01-23, where do I change that at.

[madwormer2]

Change %04d to 19%02d.

[NogDog]

raouleduke wrote:

That seems to work great, just missing one thing. The output comes out as 0048-01-23, when it should be 1948-01-23, where do I change that at.

If it's always going to be 19xx, then just change the sprintf() to:

$newDate = sprintf('19%02d-%02d-%02d', $dateParts[3], $dateParts[1], $dateParts[2]);

[raouleduke]

Yep, I got that, thanks for helping me out.

[madwormer2]

Yup ^

Lol NogDog, you're the first result on google for "misery wrapped in enema". You should be proud.

[NogDog]

madwormer2 wrote:

Yup ^

Lol NogDog, you're the first result on google for "misery wrapped in enema". You should be proud.

Story of my life. 😉