One Date does not convert

[stevejones1]

Hi

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!

[sunny_talwar]

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

[stevejones1]

CaseClosedDate , please find the attached document.

[stevejones1]

just 2017-07-10 does not change.

[uroboros]

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').....)

[diego_rojas]

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

[isingh30]

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

Thanks.

[isingh30]

Please check the below link.

Dealing with date formats in QlikView and QlikSense

Thanks.

[stevejones1]

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.

[uroboros · Accepted solution]

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))

     )