Date Format

[#1]

Hey,

I'm having a little bit of an issue with the format of dates.

Dates are being Imported in the format 20120101 000000, So YYYYMMDD HHMMSS

However I would like it to just display as YYYY-MM-DD

Is there any way of doing this??

Thanks in advance!

Natalie

[#2]

HI

DATE(DATE#('20120101 000000','YYYYMMDD hhmmss'),'YYYY-MM-DD')

[manideep78]

Try with vishwaranjan code. Its absolutely fine.

Also refer the attached link for more knowledge on date and time format

Why don’t my dates work?