Am trying to run a report monthly and daily. Was just wondering how would we create a formula for running it monthly and daily depending on the current date. i.e. if the current day is 1st of the month it should return the data for the entire previous month and if the current date is 2nd day of the month. The data returned should be for the 1st of this month. Any ideas would be appreciated.

 

 

Thanks a lot.