Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All, I have a text document that has a date format as YYYY-MM-DD.
I have a .csv file that has a date lookup relation as MM/DD/YYYY. How do I change the date format YYYY-MM-DD to be able to have the correct look up relationship as the .csv file. IE MM/DD/YYYY.
Thanks!
Hi Bill,
Maybe something like below:
Date(MakeDate(subfield('2016-07-27','-',1),subfield('2016-07-27','-',2),subfield('2016-07-27','-',3)),'MM/DD/YYYY')
Jonathan
Try this
date(date#('2016-07-27', 'YYYY-MM-DD'), 'MM/DD/YYYY')
or date(date#(your_date_field, 'YYYY-MM-DD'), 'MM/DD/YYYY')
There are some useful posts on dates and date formatting here
u can set here also
SET DateFormat='MM/DD/YYYY';
or else As colin
Try this
date(date#('2016-07-27', 'YYYY-MM-DD'), 'MM/DD/YYYY')
or date(date#(your_date_field, 'YYYY-MM-DD'), 'MM/DD/YYYY')