1 of 1 people found this helpful
By creating a calculation similar to the following, you should be able to get the desired results:
if datediff('day', [entered date], [approved date])>=30 then 'Within 30 days' else 'Over 30 Days' end
Hope this helps!
Thanks for the info Tracy, The issue i'm running into is that i have just one date field [ApprovedDate] that i want to return values for, if its 30 days or more past that approved date then return values. I tried a few variations of the line of the formula but can't seem to stumble accross anything that doesnt give me errors.
i've been trying to keep it as an if statement but get lost after the >= because the formula doesn't like an integer after, do i need to define the integer like you would in other code?
thanks for your insight!
So is there one static date that the Approved Date wants to be compared to? I'm not sure what you mean by "i've been trying to keep it as an if statement but get lost after the >= because the formula doesn't like an integer after,".
What is the formula you are trying to use?
I've actually figured out the formula that works, but the approved date is entered in by a person the day someone is approved, and this report needs to pull anyone that is 30 days or more past the approved date as well as not compliant with another field. the formula i used is:
if [ApprovedDate]<= [ApprovedDate]+30 and [PCICompliant]='0' and [PCICompliant]='NULL' then 'Within 30 days' else 'Over 30 Days' end
Thanks for all your help, you got me in the right direction!!!!