Forum Discussion
Solved
Show data in report for current month
I have a table which contains the hour logs. I have the fields "logged hours" which is a decimal and "logged on" which is a date field. In my report I need to filter the logs for the current month.
Create a calculated column like:
IsCurrentMonth = IF(MONTH([Date]) = MONTH(TODAY()),1,0)
1 Reply
- Greg_Deckler
Community Champion
Create a calculated column like:
IsCurrentMonth = IF(MONTH([Date]) = MONTH(TODAY()),1,0)