topic Re: One Date does not convert in QlikView

One Date does not convert

stevejones1 — Tue, 20 Feb 2018 19:24:44 GMT

I am trying to figure out why one dates ( 2017 - 07 - 10 ) does not convert in my data to the required format.I have tried , floor,date#,date, all the function i know .. not able to find a reason why that date remains with the timestamp in it..

Can someone help me to resolve this puzzle

Thanks!

Re: One Date does not convert

sunny_talwar — Tue, 20 Feb 2018 19:26:55 GMT

Which date is it? I see all of them read as date... can you take a screenshot to show it?

Re: One Date does not convert

stevejones1 — Tue, 20 Feb 2018 19:32:32 GMT

CaseClosedDate , please find the attached document.

Re: One Date does not convert

stevejones1 — Tue, 20 Feb 2018 19:34:13 GMT

just 2017-07-10 does not change.

Re: One Date does not convert

uroboros — Tue, 20 Feb 2018 19:51:22 GMT

hi Steve! maybe it will be a text with a diferent format, try to use the alt() Function, where you can do format for diferents types of dates, for example

Alt(date(text),date#(text,'YYYY-DD-MM').....)

Re: One Date does not convert

diego_rojas — Tue, 20 Feb 2018 19:57:02 GMT

Did you try with this?

date(floor(date#(CaseCloseDate,'MM/DD/YYYY')))

I think that maybe you have to convert the field in a number and later apply the floor function.

Let me know if it works

Re: One Date does not convert

isingh30 — Tue, 20 Feb 2018 20:00:57 GMT

Please select Number tab in the list box & click on override document setting & select Date format.

Thanks.

Re: One Date does not convert

isingh30 — Tue, 20 Feb 2018 20:07:07 GMT

Please check the below link.

Dealing with date formats in QlikView and QlikSense

Thanks.

Re: One Date does not convert

stevejones1 — Tue, 20 Feb 2018 20:18:03 GMT

if i use Alt and when i put Caseclosedate in list box i see value for each date instead in 1 values of a date with different timestamps .. how do i avoid that .. can you please provide full expression.

Re: One Date does not convert

uroboros — Tue, 20 Feb 2018 20:33:12 GMT

Dear Steve, maybe you have some trouble with a date cast, for these values use another format

This Expresión will be usesfull:

Alt(

Date("DateText"),

Date(Date#("DateText",'YYYY-DD-MM')),

Date(Date#("DateText",'DDMMYYYY hh:ss tt'),

.....(Here you can put another format to cast))

)