Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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
I changed, in this case calendar doesn't work
Hello,
Use the date function in the script editor.
Date(floor(submitDateTime), 'M/D/YYYY') as oDate
Regards
Yoann
in this case calendar doesn't work
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...
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.
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);
Thank you
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