Hi All
I need help trying to work out the criteria for showing all dates within January of the current year.
If I was running this report in a years time, I would want it to show January 2016's dates.
Thanks
Hi All
I need help trying to work out the criteria for showing all dates within January of the current year.
If I was running this report in a years time, I would want it to show January 2016's dates.
Thanks
Hi,
Try the following:
Start Date:
=DATE(YEAR(TODAY()),1,1)
End Date:
=DATE(YEAR(TODAY()),1,31)
Year will be decided based on TODAY()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks