Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

stevejones1
New Contributor III

One Date does not convert

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!

1 Solution

Accepted Solutions
uroboros
Contributor

Re: One Date does not convert

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

     )

9 Replies

Re: One Date does not convert

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

stevejones1
New Contributor III

Re: One Date does not convert

CaseClosedDate , please find the attached document.

stevejones1
New Contributor III

Re: One Date does not convert

just 2017-07-10 does not change.

uroboros
Contributor

Re: One Date does not convert

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

Highlighted
Partner
Partner

Re: One Date does not convert

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
Valued Contributor

Re: One Date does not convert

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

Thanks.

isingh30
Valued Contributor

Re: One Date does not convert

Please check the below link.

Dealing with date formats in QlikView and QlikSense

Thanks.

stevejones1
New Contributor III

Re: One Date does not convert

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
Contributor

Re: One Date does not convert

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

     )