R
Rich
Guest
I use the following to group by fiscal year without any problem but I need to get the difference in weeks between Date and the start of the current financial year
FYear: Year([TrDate])-IIf([TrDate]<DateSerial(Year([TrDate]),5,1),1,0)
Any ideas?
FYear: Year([TrDate])-IIf([TrDate]<DateSerial(Year([TrDate]),5,1),1,0)
Any ideas?