Static from Date 1

[Desertbratt]

Hi, I need to find posted data from the 7th of each month thru the end of any given month. i.e. the 7th of every month thru the end of the month. Any ideas?

Thanks!

 

[lbass]

You could use a selection formula like this:

{table.date} in date(year(currentdate),month(currentdate),7) to
dateserial(year(currentdate),month(currentdate)+1,1)-1

If you are using a date parameter, you can substitute that for currentdate.

-LB

 

[Desertbratt]

Thanks, I'll give it a try tomorrow!

 

[Desertbratt]

I tried using this formula and I seem to be getting dates before the 7th of the month, like the 1st thru 3rd and so on.

{HSP_TRANSACTIONS.TX_POST_DATE}in Date(Year(CURRENTDATE)
,month(CURRENTDATE),7) to dateserial(year(CURRENTDATE)
,month(CURRENTDATE)+1,1)-1


Here's the formula.

 

[lbass]

Sorry, but that wouldn't be possible. Are you sure you are looking at the same date fields in the report and the in the formula?

-LB