Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need your help to convert a number like 200903 to date format, how to do that?
I used date function: date(cur_date, 'YYYYMM'), cur_date variable has values of 200903, 200904...somthing like that. However I got 245001 as a result...Anyone knows why?
Thanks a lot!
Hi,
As all Say Date#() will help you
You use like this way
Date(Date#(YourDateFieldName,'YYYYMM'),'MMM-YYYY')
Regards
Try using date#
Try Date#
=date(date#('200903'),'YYYYMM'))
-Rob
Hi,
As all Say Date#() will help you
You use like this way
Date(Date#(YourDateFieldName,'YYYYMM'),'MMM-YYYY')
Regards