Change date format

[#1]

HI all,

I am using the below expression to change the date format but it's not changing.

yearend(max(CanonicalDate,'MM-DD-YYYY'),-1)

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

Thanks,

Pramod

[sunny_talwar]

Not sure what you are trying to do, but may be this:

Date(YearEnd(Max(Date#(CanonicalDate, 'MM-DD-YYYY'))), 'MM-DD-YYYY')

[Colin-Albert]

There are a couple of great posts on getting dates correct here :

https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work?_ga=1.9590658...

https://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right

[Anonymous]

Try like:

=yearend(date(max(CanonicalDate),'MM-DD-YYYY'),-1)

[#5]

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

[hic]

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

    Date(YearEnd(...

Instead I would use

    Date(Floor(YearEnd(...

HIC