Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Our fiscal calendar is defined as fiscal year and week. I am trying to open a document which would by default select the fiscal year we are in and the previous fiscal week.
Please see attached sample file with the calendar loaded. The calendar is generated using QVD from another application that I can't really access or modify.
How can I achieve the above? Please advise.
Thanks,
Amit
Your condition works well as expected. for 2017, You have 53 weeks which means before week should be 52 only. you are not expecting that then what is the expected logic value to pick the 51?
No it just giving me 1 week before the max FISCAL_WEEK. I need to give me the previous FISCAL_WEEK based on the current date (today).