Numbers instead of dates

[Anonymous]

Hi,

I have a file, where I have calendars.

I'd like to see real dates instead of numbers in current selection.

Please find my attached file.

Regards,

[salto]

Hi Vladimir,

maybe you should change the date format of the field in the script:

LOAD submitDateTime,

...

date(floor(submitDateTime,'MM/DD/YYYY')) as oDate

...

Hope this helps

[Anonymous]

I changed, in this case calendar doesn't work

[yduval75]

Hello,

Use the date function in the script editor.

Date(floor(submitDateTime), 'M/D/YYYY') as oDate

Regards

Yoann

[Anonymous]

in this case calendar doesn't work

[Anonymous]

Hi,

Some how I could not open your file, I guess u have time stamp for your date column just use Floor() as oDate which will truncate timestamp if it not once check your max and min dates from your calender  if they are throwing float values or any other values than expected,try using Date(Date#(min(oDate))) for min and max values... Hope it Works...

[salto · Accepted solution]

Hi,

the syntax of the trigger in variables vStart and vEnd need to be changed to:

='>=' &date(vStart,'MM/DD/YYYY') & '<=' &date(vEnd,'MM/DD/YYYY')

Now the calendar works. PFA.

Hope this helps.

[preminqlik]

TRY THIS :

LOAD submitDateTime,

DATE(Timestamp#(submitDateTime)) AS date,

     [qID_15863_Purpose of Visit],

     [qID_15879_Next step],

     MonthName(Monthstart(date(submitDateTime))) as MYear,

floor(submitDateTime) as oDate

FROM

C:\Users\Desktop\Book1.xlsx

(ooxml, embedded labels);

[Anonymous]

Thank you

[salto]

Hi.

Don't forget to mark the answer as correct... It may help other users.

Regards.

El 23/10/2013, a las 18:10, Vladimir Kostochka <qcwebmaster@qlik.com> escribió:

QlikCommunity

Re: Numbers instead of dates

reply from Vladimir Kostochka in New to QlikView - View the full discussion

Thank you

Reply to this message by replying to this email, or go to the message on QlikCommunity

Start a new discussion in New to QlikView by email or at QlikCommunity

Following Re: Numbers instead of dates in these streams: Inbox

© 1993-2013 QlikTech International AB Copyright & Trademarks | Privacy | Terms of Use | Software EULA