In this condition I only want it to enter the BEGIN if the Date field 'Coshh Review Date' is greater than or equal to the WORKDATE + 30Days (Month). This is what I tried but it appears to be allowing dates over the 30 days. Any help will be appreciated!
IF recItem."Coshh Review Date" >= CALCDATE('<-' + recJobQueueEntry."Parameter Value 1" + 'D>', WORKDATE) THEN BEGIN
*This post is locked for comments
Please let us know if your problem is still not solved.
IF recItem."Coshh Review Date" >= CALCDATE('<' + recJobQueueEntry."Parameter Value 1" + 'D>', WORKDATE) THEN BEGIN should work
Or to avoid your confusion store the value of the expression CALCDATE('<' + recJobQueueEntry."Parameter Value 1" + 'D>', WORKDATE) in a date variable first before the comparison and compare that with review date. Try Message Box to output the value of the date variable and use your IF statement accordingly.
If you need 30 as fix, as suggested previously you can use:
CALCDATE('<30D>',WORKDATE)
Or if you need that to be parameterised then you can use:
CALCDATE('<' + FORMAT((DateVariable)) + 'D>', WORKDATE)
-Yogesh Kulkarni
Please verify, if you find answer helpful.
then use
IF recItem."Coshh Review Date" <= CALCDATE('<' + recJobQueueEntry."Parameter Value 1" + 'D>', WORKDATE) THEN BEGIN
I want it so calculate if the date field is within 30 days of the workdate, so for example if the date field was set to 03/02/2017 or any date inbetween that and the workdate it will be accepted.
do you want to calculate (WORKDATE + 30D) or (WORKDATE-30D)?
I understood it as -30D.
Use IF (recItem."Coshh Review Date" >= CALCDATE('<' + FORMAT((-1* intDate)) + 'D>', WORKDATE) ) THEN BEGIN
FORMAT will convert your Integer value to Text and you can concatenate that.
-Yogesh Kulkarni
Please verify, if you find answer helpful.
thanks for the help!
I've set a date to 23/03/2017 which shouldn't be accepted but it still is.
Use FORMAT((-1* intDate))
I'm unable to change it however I tried another solution,
IF recItem.FINDSET(FALSE, FALSE) THEN REPEAT
EVALUATE(intDate,recJobQueueEntry."Parameter Value 1");
IF (recItem."Coshh Review Date" >= CALCDATE('<' + (-1* intDate) + 'D>', WORKDATE) ) THEN BEGIN
This however errors before the + and says "Type Conversion is not possible... Text + Integer
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (