I am trying to generate 2 monthly reports: One comes out on the first of the month and one comes out on the 16th of the month. I have a Start Date field. I'm trying to figure out how to filter the reports so the jobs with Start Dates fall on these reports:
First of the month: Start Date on or after the 21st of 2 months previous and Start Date on or before the 5th of the previous month (i.e for the February 1 report, Start Date would be December 21 - January 5
16th of the month: Start Date on or after the 6th of the previous month and Start Date on or before the 20th of the previous month (i.e. for the February 20 report, Start Date would be January 6 - January 20)
------------------------------
Terri
------------------------------
Question
Date Formula for Reporting
This topic has been closed for replies.
+15Terri,
If these two reports are the only place that you care about the Numerical Day in the field [Start], then a simple solution is to use Report Formulas.
Here is a screen shot of it being set up. This assumes that [Start] is Date field and NOT a Date/Time field. If this assumption is false then inside the formula you first have to convert [Start] to a Date and then use Day() on the result.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
If these two reports are the only place that you care about the Numerical Day in the field [Start], then a simple solution is to use Report Formulas.
Here is a screen shot of it being set up. This assumes that [Start] is Date field and NOT a Date/Time field. If this assumption is false then inside the formula you first have to convert [Start] to a Date and then use Day() on the result.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.