Crystal XI Date Formula

[pungigi]

I have a report designed which references the following formula:

TAPTDT is in the period of AllDatesToYesterday, is there a way to say...

AllDatesThruMidMonth or END OF MONTH???

 

[synapsevampire]

You'd need to state what midmonth is to you, does that mean the 15th, or?

Here's how to get an end of the month:

dateserial(year(currrentdate),month(currrentdate)+1,1)-1

So a record selection formula might look like:

{table.date} <= dateserial(year(currrentdate),month(currrentdate)+1,1)-1

For midmonth it might be:

{table.date} <= dateserial(year(currrentdate),month(currrentdate),15)

End of month isn't very descriptive either, do you want this month, last month, or?

Hopefully you'll understand the above and it will prove applicable for your needs.

-k

 

[pungigi]

Sorry so unclear, what happens is around the 10th of each month I run a report that needs to be Earliest out there thru end of prior month and then around the 26th of each month I run a report that needs to be earliest out there thru mid/15th of prior month. Will your formulas work for this scenario???