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.
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!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.