Discussion board where members can get started with Qlik Sense.
I am using the below expression to change the date format but it's not changing.
I need the count till last year end. in my db the date format is 'MM-DD-YYYY' so i am using above expression but it's not changing.
it's printing in 'MM/DD/YYYY' when i print in text box
Not sure what you are trying to do, but may be this:
Date(YearEnd(Max(Date#(CanonicalDate, 'MM-DD-YYYY'))), 'MM-DD-YYYY')
There are a couple of great posts on getting dates correct here :
Can you please help on this,
I am trying to get the count from particular date but i am not able to get.
I am attaching the .qvf file.
Data from 11-30-2014 31-12-2014.
Please check my KPI
Careful here... YearEnd returns a timestamp that is not an integer, and the non-integer part is hidden by the Date() function. This can cause problems. I would not use
Instead I would use