Date issue

[Mahamed_Qlik]

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

[settu_periasamy]

Hi,

Try like

Date(Floor(PurchaseDate),'MM/DD/YYYY')

[Saurabh_K14999]

Hi,
Use the below given format and functions for your requirement.

Date(PurchaseDate,'MM/DD/YYYY') as PurchaseDateNew

Regards,
SK

[Mahamed_Qlik]

Hi Surabh

This I have tried but for few dates from the list it is not working.

[sunil0099]

Hi

Mahamed

Can you please use the 

Date(Dayname(Fieldname),'MM/DD/YYYY') as PurchasedDate

[MarcoWedel]

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
];