J
jim
How to report a date in fiscal qtr's, our fiscal year begins Nov 1 of the
year. How to covert a date to format like 2005-Q1, 2005-Q2 when using
crosstabs and reports?
I already use:
Qtr: Format(DateAdd("m",2[Table2].[Date]), "Qqyy")) Q105, Q205, etc would
like 2005-Q1, 2005-Q2, etc
year. How to covert a date to format like 2005-Q1, 2005-Q2 when using
crosstabs and reports?
I already use:
Qtr: Format(DateAdd("m",2[Table2].[Date]), "Qqyy")) Q105, Q205, etc would
like 2005-Q1, 2005-Q2, etc