Fiscal calendar

[stephenedberkg]

I have the date field.

i have to change start date of the year is 16-12 for all the year

16-12-2016 to 15-01-2017 for jan month

16-02-2017 to 15-03-2017 for feb month

i have attached the sample date please find it .

thanks in advance

[tresB]

Try like:

Load

          Date,

          Month(Date-15) as Month

[stephenedberkg]

if i click the month jan 2017 mean it should calculate the data form

dec 16-12-2016 to 15-01-2017

id	Sales	date
2	200	20-12-2016
4	400	13-01-2017

sales values is 600

[tresB]

It should be '+' then. Try:

Month(Date + 15) as Month

[stephenedberkg]

how to add this in master calandar

[tresB]

When you create month in the master calendar, use this code.

[stephenedberkg]

this is my sample data ...

i am using master calandar in my application

before that i am using normal master calandar

but now client ask 1st date of the year is 16-12 like wise

[tresB]

May be I could not make it clear. Let me explain it again. When you create a master calendar, you use script something like:

Load

          Date,

          Month(Date) as Date,              // just replace this script with the one I suggested above.

          Year(Date) as Year

From <>; // or may be using autogenerate

[stephenedberkg]

thank you but

all the month i should take the 16 day only

but iin 31 days month it takes 17 th day

30 month it take 16 th day

[tresB]

Try like:

Load

       Date,

       Month(Date) as ActualMonth,

       Year(If(Day(Date)>=16, Addmonths(MonthStart(Date),1), Date)) as CustomYear,

       Month(If(Day(Date)>=16, Addmonths(MonthStart(Date),1), Date)) as CustomMonth;

Load

  Date(AddYears(Today(),-1)+RecNo()) as Date

AutoGenerate 800;