Month not reflects date

[nareshthavidishetty]

Hi the user financial year is fro FEB to JAN

so i have created month start from FEB

but it doesn't reflects the date means if i click on FEB month it gives JAN data as below for your reference,

[renuka_sasikumar]

Hi

First derive one variable

LET vFM = 2;

And then in your Load statement use this

Mod(If(Len(Num(Month(Date)))<2,0 & Num(Month(Date)),Num(Month(Date))) - $(vFM), 12)+1 as fMonth

This will give you financial year starting from Feb.

Regards,

Renuka S

[renuka_sasikumar · Accepted solution]

Hi

Check this attachment which will be useful for you.

Its a Master Calendar.

Regards,

Renuka S

[nareshthavidishetty]

Thanks Renuka ,but what about the quarter

[renuka_sasikumar]

Most welcome Naresh.

Check in attachment everything you have in it.

Just use your field name instead of Date.

'Q' & Ceil((Mod(If(Len(Num(Month(Date)))<2,0 & Num(Month(Date)),Num(Month(Date))) - $(vFM), 12)+1)/3) as Quarter,

Year(Date) + If(If(Len(Num(Month(Date)))<2,0 & Num(Month(Date)),Num(Month(Date))) > =$(vFM), 1, 0)-1 as fYear,

Hope you got it

[sunny_talwar]

Also look at the blog for tips to create fiscal calendar:

Fiscal Year

Fiscal and Standard Calendar generation

[nareshthavidishetty]

Hi am getting months as 1,2,3,4,....12 i need to show month names 1=feb,2=mar,.....12=Jan

[sunny_talwar]

Is it still not working based on Renuka's responses? Have you looked at the second link I shared. jagan‌ has provided the script to create a fiscal calendar. Try it out.

[renuka_sasikumar]

Derive Month(Date) as MonthName along with the above expression.

If possible post your app.

Regards,

Renuka S

[senpradip007]

Have look at this.