Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
DATE(DATE#('20120101 000000','YYYYMMDD hhmmss'),'YYYY-MM-DD')
Try with vishwaranjan code. Its absolutely fine.
Also refer the attached link for more knowledge on date and time format