Hi, I have reports that show data for the previous month, and then the same data in a YTD view. The calculation for YTD is: Year([Field1]) = Year Now())
However, actually - I only want to show data from the start of the year until the end of the previous month, so no current month data is included.
The only way I know how to do this is using Between Date and hardcoding '2012', but I don't want to do this for obvious reasons. Is there another way of doing this?
Thanks in advance,
Kirsti