Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guru's,
I am converting Date into below format ,but it's not showing date
Date(Date#(Date,'M/D/YYYY'),'MMDDYYYY')
Current Date format ='M/D/YYYY'
Any Help
-Sateesh
Try like this
Date(Date#(Date),'MMDDYYYY')
Or
Date(Date,'MMDDYYYY')
Try this ways but check previous date format is correct other wise make it correct
Date( Date(Date#(Date,'M/D/YYYY'),'M/D/YYYY') 'MMDDYYYY')
Try to share sample data or file.
Regards
Anand
Hi ,
Your syntax seems correct for me. Check your date field format again i.e 'M/D/YYYY'.