Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems With Dates

Hello All,

I would like your help.

I have a number of tables which have dates, like so:

Screenshot (90).png

Screenshot (91).png

And a master calendar that looks like so:

Screenshot (92).png

Yet, in the UI, only the dates coming from the merchandise income tables are showing up.

As you can see here:

Screenshot (93).png

Please can someone tell me why this is, and what can be done about it.

Thank you all in advance,

Alison

5 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

Try use function Date() for field [Date]? Like this Date([YourDateExpression]).

Regards,

Andrey

Not applicable
Author

Hi Andrey,

Thank you for your response.

However, I believe I am already using the Date function.

ahaahaaha
Partner - Master
Partner - Master

In the picture in MasterCalendar date field is used with the function Text(). May be Text() change to Date()?

Not applicable
Author

Hi Again,

Sorry, I misunderstood you.

Ok I have now done that and I get the following result:

Screenshot (94).png

So it's different but not better.

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

the problem with the Date field is like it is already being said the date format. So in other words, no matter the number of functions you apply to your date, your outter function should be date, like this

Date(Monthstart($(vMinDate) + RecNo() -1)) as Date

Also, the num and text functions are not necessary nor useful in this case,

Date/Time functions could be a little confusing to get into them, but once you understand them you'll see how useful they are,

hope this helps

regards