Another Date Question - Iif Between

[kwj1027]

Trying to create a formula to select records from yesterday and today with:

Iif (Between ( {@REQDATE}, CurrentDate, CurrentDate-1 ) , {'Actual'} , NULL )))

Getting the error message ") is missing" and (Between is highlighted.

{@REQDATE) } is a date field from JDE that is created with the formula:

(Date(truncate({F4801.WADRQJ} / 1000) + 1900 , 1, 1)
+ Remainder ({F4801.WADRQJ},1000)
- 1)

Hope that this is enough information to assist with this solution. If not let me know and I'll add as needed.

TIA,

Kevin

 

[lbass]

Try using a simple if/then instead.

if {@Reqdate} in currentdate-1 to currentdate then "actual"

Or if this is for record selection, use:

{@Reqdate} in currentdate-1 to currentdate

-LB

 

[kwj1027]

LB,

Excellent worked perfectly!

Thank you for your time and assistance.

Regards,

Kevin