Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dates in Text Objects

Hi,

I've been reading around and haven't been able to find any information on this, so i'll give this a shot.

I would like to create a label via the Text object that displays something along the lines of

'Information from (start date) to (end date) for so and so'

I've put this:

date#(@10,'MM/DD/YYYY') as [Date of Service], Month(@10) as Month, Year(@10) as Year,
date(DayStart(@10), 'MM/DD/YYYY') as SDay,
date(DayEnd(@10), 'MM/DD/YYYY') as EDay,

in my script, but when I enter this

='Data dates from ' & [SDay] & 'to ' [EDay]

into the expression box, I get a null value.

Any idea where I'm going wrong?

10 Replies
Not applicable
Author

Thanks for clearing that up Karl!