Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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))

     )

View solution in original post

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

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

     )

View solution in original post