Need help using Today in an if formula in Epcior 9 BAQ

I want to return a result if a date is less than today. I keep getting a syntax error but I thought I had done this previously.

maybe in here…

You could set criteria on the table you are wanting to filter the date on and use a baq constant to tell it get all records that are less than or equal to Today’s date instead of using a formula. Not sure if this is what you are after but just throwing this out there as another way to do it.


I need this for Epicor 9

If Today - QuoteHed.ExpectedClose > Today Then “NEEDS ATTENTION” Else " "

I’ve not used E9. But from that link I posted it looks like you might want

If Today - QuoteHed.ExpectedClose > 0 Then “NEEDS ATTENTION” Else " "

Today - QuoteHed.ExpectedClose could only ever be > Today, if QuoteHed.ExpectedClose was negative

Why not just check that ExpectedClose date is greater than today?
If QuoteHed.ExpectedClose > Today Then “NEEDS ATTENTION” Else " "