Date format

[johnan]

Hi,

I have from DB = 20091010

and time 14934

I want to format date to 2009-10-10
And the time to 01:49:34

[#2]

In one of my cases I did like this:

1. Parsed the day, month and year for date and hour,minute,seconds from time.

2. Used makedate() and maketime() to derive the date and time in the desired format.

Would this help?

--Arun

[johnan]

Hi, no i'ts not working

[#4]

Oops...

But something like this should work...?

date(MakeDate(left(Date,4),mid(Date,5,2),right(Date,2)),'YYYY-MM-DD')

where Date is your input.

--Arun

[johnan]

Hmm, todays date give me 40103 now

[#6]

If your DB is a string, definitly this should work. See my example, below expression in a text box gives me the correct result:

=date(MakeDate(left('20091009',4),mid('20091009',5,2),right('20091009',2)),'YYYY-MM-DD')

If DB is numeric, can't we use similar numeric functions to parse? May be I'm thinking too basic than what you expect..

--Arun