topic Re: Date issue in QlikView

Date issue

Mahamed_Qlik — Thu, 10 Nov 2022 06:43:46 GMT

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

Re: Date issue

settu_periasamy — Thu, 10 Nov 2022 06:51:21 GMT

Hi,

Try like

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

Re: Date issue

Saurabh_K14999 — Thu, 10 Nov 2022 07:03:52 GMT

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

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

Regards,
SK

Re: Date issue

Mahamed_Qlik — Thu, 10 Nov 2022 07:37:08 GMT

Hi Surabh

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

Re: Date issue

sunil0099 — Thu, 10 Nov 2022 08:02:48 GMT

Mahamed

Can you please use the

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

Re: Date issue

MarcoWedel — Sat, 12 Nov 2022 18:00:53 GMT

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