How to compare data (up or down) based on monthly date
I have a report that has data for each month.This report will be run every on 1st of every month. The report will have to display sells and whether the sales are going up or down based on 1st of each month. I need help with the code. How do I compare the dates? How do I tell the program which date is previos when comparing to the current one?