Calendar Field

[#1]

Hi All

I have a "Date" field and would like to use to create a BudgetMonth Field based on two dates.

The condition is that the budget months starts on the 26th of every months and ends on the 25th. I would like to create a Field that can give me a result like this: from 26 December to 25 January "Dec - Jan", from 26 January to 25 February "Jan - Feb"

How can I write this expression?

[sunny_talwar · Accepted solution]

This?

Script:

Table:

LOAD *,

  If(Day(Date) < 26, Month(Date) & ' - ' & Month(AddMonths(Date, -1)), Month(AddMonths(Date, 1)) & ' - ' & Month(Date)) as BudgetMonth;

LOAD Date(MakeDate(2014, 12, 31) + RecNo()) as Date

AutoGenerate 730;

[Chanty4u]

hi,

https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

chk abve link

[#4]

Thanks ...my expression was slightly different hence wit was not working