Date issue

[johnan]

Hi All!

I have a date field: 90915 (numeric)

I Want to convert to 2009-09-15

Can i do that?

[#2]

Hi Johnan,

use this: date(90915, 'YYYY-MM-DD');

But 90915 is not 2009-09-15 but 2148-11-29

Rey-man

[johnan]

Yes, iknow.
I think we have to convert and not use date function? Or the first zero in year will doit?

[#4 · Accepted solution]

Hi,

Something like this: date(date#(Num(DATE,'000000'),'YYMMDD')) as Date

But what about 2010? Will it be displayed like this: 100915?
Use the function in your script. 😉

Greetz
Robbie

[johnan]

That doit it 🙂
and 2010 woks.
Can i do this with a timefield to?

93126
09:31:26

[#6]

Hi,

For time tyr this: time(time#(Num(F2,'000000'),'hhmmss')) as Time

Greetz
Robbie

[johnan]

Thanx, this works!