last Fiscal Week

[bobbydave]

i am trying to get the last week's fiscal week

So for

Fiscal Year Week 2017-26,

i should get

Fiscal Year Week =2017-25

I cant simply write an expression Fiscal Year Week -1

[Anil_Babu_Samineni]

How you are getting 2017-26 ??

[bobbydave]

From my calendar

[bobbydave]

Doesnt necessarily have to be 2017-26

Could be 2017-02

[Anil_Babu_Samineni]

I know that, I am expecting how you are getting 26 week? Does your fiscal start from Which month? May be share application / script?

[bobbydave]

I just made up the example of 2017-26

It could be 2016-04 from my T_Calendar.qvd

[Anil_Babu_Samineni]

I am sorry to say - Question not clear. May be better explain each line and show some sample data set and that demonstrates the issue?

[bobbydave]

So What I want to do is to get Fiscal Year Week to show me the previous week

So 2016-30 would show 2016-29

[Anil_Babu_Samineni · Accepted solution]

If you need that, Don't use Direct function to get that value

WeekName(DateField) as Fiscal_WeekName

You can use something like below

Year(DateField) & '-' & Week(DateField)-1 as Fiscal_WeekName