FInd my approach as reference below in attached workbook version 9.3 located in the original thread.
1. MTD: if datediff('month',[date],[date Parameter])=0 and [date]<[date Parameter]-1 then [value] END
2. Current Month: if datediff('month',[date],[date Parameter])=0 then [value] END
PS please change your name to your "real name" We try to keep this forum as open an transparant as possible. Thank in advance for your cooperation.
MTD Current Month_nalmai.twbx 52.8 KB
Great thank you very much Norbert!
I had another quick question if that is okay. I am also trying to display the week commencing dates for the month we are on currently. However I need the week commencing dates to start from the 1st of the month. For example if I am reporting for the month March, I dont want the week commencing date 27th Feb (as I just want March). Does that make sense?