Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to convert the following date (getting as text from database) to date format as 'YYYY-MM-DD': "2009-12-18T10:30:38.000Z".
Following command is not working because it is a text:
date('2009-12-18T10:30:38.000Z', 'YYYY-MM-DD');
Thanks
Samir
Hi,
Samir
Try this its working
=date(makedate(left('2009-12-18T10:30:38.000Z',4),mid('2009-12-18T10:30:38.000Z',6,2),mid('2009-12-18T10:30:38.000Z',9,2)),'YYYY-MM-DD')
regrads
Kaushal mehta
date(date#(myDate,'YYYY-MM-DD hh:mm:ss.fff),'YYYY-MM-DD')
It's possible that you have to loose the T and Z since that can't be found in documentation.
Hi,
Samir
Try this its working
=date(makedate(left('2009-12-18T10:30:38.000Z',4),mid('2009-12-18T10:30:38.000Z',6,2),mid('2009-12-18T10:30:38.000Z',9,2)),'YYYY-MM-DD')
regrads
Kaushal mehta