Do you have a sample workbook to share?
Are you able to share your workbook for this? I'm not completely following your question.
So if today's date is greater than the 15th of the month, you want the calculated field to return a string that says "16th - 30th"? Or do you want the calculated field to return TRUE if it's between the 16th and 30th?
i can't share the workbook because of some restrictions. The req is, need to have boolean filter, status date = June 1st to June 15th, it should pull the date between june 1st and june 15th, since todays date is june 24th. When July 1st comes, it should pull the data from june 16th to june 30th////
DATE(IF DAY([Date]) < 15 THEN DATETRUNC('month',[Date] )
ELSE DATEADD('day', -1,DATEADD('month',1,DATETRUNC('month',[Date] )))
Here you go I tried it in mine and if you want to include the 15th in the 1st of the month part do <= instead of <
Thanks Sashank, I think I understand.
So you want it to include status dates of the 16th through the end of the month if todays date is greater than the 15th. If today's date is less than or equal to the 15th, only include Status Dates of the 1st through the 15th. You can do that like this:
if datepart('day',today()) > 15
then if datepart('day', [status date]) > 15 then "Include" else "Exclude" end
elseif datepart('day',today()) <= 15
then if datepart('day', [status date]) <= 15 then "Include" else "Exclude" end
Drag that field onto your filter shelf and select "Include". Let me know if that works for you.