Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a calendar table with date field as YYYY/MM/DD (Data Warehouse table)
I would like to convert all dates into MM/DD/YYYY while loading the table from DW.
Regards,
H
Hi
Try like this
Date(DateField,'MM/DD/YYYY') // If its in date format.
or
Date(Date#(DateField,'YYYY/MM/DD'),'MM/DD/YYYY') // If its not in date format
Hi
Try like this
Date(DateField,'MM/DD/YYYY') // If its in date format.
or
Date(Date#(DateField,'YYYY/MM/DD'),'MM/DD/YYYY') // If its not in date format
Hi Mayil,
Thanks for the solution---- > Date(Date#(DateField,'YYYY/MM/DD'),'MM/DD/YYYY')
If I want to convert it to MM/DD/YY 00:00:00 ?
Regards.
H
Hi
Try like this
Date(Date#(DateField,'YYYY/MM/DD'),'MM/DD/YYYY hh:mm:ss')