date conversion

[#1]

Hi all ,

my date format is 20070624.

i need 2007-60-24

please help me

[arulsettu · Accepted solution]

try this

date(Date#('20070624','YYYYMMDD'),'YYYY-MM-DD')

[avinashelite]

try like this

Date(Date_field,'YYYY-MM-DD')

or

Date(date#(Date_field),'YYYY-MM-DD')

[Chanty4u]

try belwo

date(Date#('Datefield','YYYYMMDD'),'YYYY-MM-DD') as new date

[MindaugasBacius]

Date# will interpret the number as Date. By YYYYMMDD you're defining what kind of date format you have, helping QV to understand how the data is set.

Date will now convert the data into format that you wish.

All the above solutions are correct and should work for you.

[Anonymous]

=(Date(Date#((20070624),'YYYYMMDD'),'DD-MM-YYYY'))