Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
I have column with below date format:
PurchaseDate
1/2/2011 12:00:00 AM
12/3/2012 12:00:00 AM
12/20/2018 12:00:00 AM
4/25/2022 12:00:00 AM
I want only date to be extracted in MM/DD/YYYY format as below :
PurchaseDate
01/02/2011
12/03/2012
12/20/2018
04/25/2022
Regards,
Mahamed
Hi,
Try like
Date(Floor(PurchaseDate),'MM/DD/YYYY')
Hi Surabh
This I have tried but for few dates from the list it is not working.
Hi
Mahamed
Can you please use the
Date(Dayname(Fieldname),'MM/DD/YYYY') as PurchasedDate
table1:
LOAD Date(Date#(SubField(PurchaseDate,' ',1),'MM/DD/YYYY'),'MM/DD/YYYY') as PurchaseDate
Inline [
PurchaseDate
1/2/2011 12:00:00 AM
12/3/2012 12:00:00 AM
12/20/2018 12:00:00 AM
4/25/2022 12:00:00 AM
];