Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date table with fiscal week numbers

Hi    Can i get some advice on how to write a date table with fiscal week number please . our company fiscal week starts on the first week of april and ends on the last week of march the following ...
Need Help
  • mwegener's avatar
    mwegener
    4 years ago

    Hi Anonymous ,

     

    Did I answer your question?
    Please mark my post as solution, this will also help others.
    Please give Kudos for support.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi mwegener 

 

Thanks for the reply and i have tried but there is an error message says

 

Token Eof expected and not sure what happened as i did copy your code & pasted in. Screen shot below.

 

Thanks

 

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

You have a space between __ and FW.  Delete that.

 

Pat

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi mahoneypat 

     

    There is a error message when delete to space 

     

    Maybe somewhere along the line that i've done wrong but just trying to have a calander that will have the date,fiscal week,fiscal quarter & fiscal year on it. 

     

    Thanks