topic Re: Date format help in QlikView

Date format help

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me to convert the below date formats.

I have extracted Date1 and Date2 fields from SharePoint and stored in to qvd.

When I have taken those dates into table I am getting below format.

Here I have to show 13/06/2017 for 2017-06-12T23:00:00Z and

15/06/2017 for 2017-06-14T23:00:00Z etc...

Please help me on this.

Thanks in advance.

YoussefBelloum — Wed, 20 Jun 2018 11:53:30 GMT

Hi,

try this:

Date(TimeStamp#(Date),'DD/MM/YYYY') as Date

mahitham — Wed, 20 Jun 2018 12:12:01 GMT

Hi Youssef,

Thanks for your reply.

By applying the above syntax for Date1 I am getting 12/06/2017 but that format is equal to 13/06/2017.

2017-06-12T23:00:00Z here T23:00:00Z need to consider.

Please help me on this.

jyothish8807 — Wed, 20 Jun 2018 12:43:43 GMT

Hi Mahitha,

Try this:

ConvertToLocalTime(timestamp#(replace(F1,'T',' '),'YYYY-MM-DD hh:mm:ssZ'),'Kolkata') as Date;

Note: F1 will be your date field

Br,

jyothish8807 — Wed, 20 Jun 2018 12:47:53 GMT

Add a date parameter out side:

date(ConvertToLocalTime(timestamp#(replace(F1,'T',' '),'YYYY-MM-DD hh:mm:ssZ'),'Kolkata'),'DD/MM/YYYY') as Date;

mahitham — Wed, 20 Jun 2018 12:59:51 GMT

Thanks a lot Jyothish

neelamsaroha157 — Wed, 20 Jun 2018 13:01:35 GMT

If date formatting is not working for you then may be you can use makedate(left(Date,4), mid(Date,6,2), mid(Date,9,2)).

jyothish8807 — Wed, 20 Jun 2018 13:05:01 GMT

You are welcome