This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am using the following formula, but all results are coming back true.
if datetimediff(DateTimeTrim([ApprovedDate],"firstofmonth"),[ApprovedDate],"days")<=5 then1 else 0 endif
Thanks in advance!
Hi @TMHC ,
I recognized that you would like to judge the [ApprovedDate] within 5 at the beginning of the month.
The start and end dates are reversed at DateTimeDiff expression.
This is the correct expression.
if datetimediff([ApprovedDate],DateTimeTrim([ApprovedDate],"firstofmonth"),"days")<=5 then
1 else 0 endif
If the complex expression doesn't work well, I recommend that you cut up them into pieces.
You can pull the records using a filter if the [ApprovedDate] is in date format by using a custom filter formula of:
Thank you so much. That worked!
I'm glad it works well.
If you have solved the problem, it would be helpful if you could accept it as a solution so that people can refer to it later.