Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi steve,
LastDate currentDate event
12/10/2017 22/10/2018 diwali
22/11/2017 12/10/2018 durga pooja
so, I have maintained following above table in inline table and also
I have derived lastDate and CurrentDate from (circled in black color)
Date#(CreateDate, 'YYYYMMDD') as Sold_Date,
date(Date#(CreateDate, 'YYYYMMDD')) as lastDate,
date(Date#( CreateDate, 'YYYYMMDD')) as CurrentDate,
Following is the data model for the above
paint.png
Below is the image in which date for inline table is not correct ie I am getting 10/21/4670 instead of 10/21/2017
so how to make it correct?
can we apply date function in inline table in qlikview?
Try to make it as Format
and, I also suggest don't create multi threads for single issue like