Workdate + 30D

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (17)

Answers (1)

Community Member on at

Like (0)

Report

Parameter Value 1 is set to 30*

Was this reply helpful? Yes No
Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

CALCDATE('<30D>',WORKDATE) this will add 30 days to the workdate, in your scneario you are using <-30D> change that and you should be good.

Change '<-' to '<'

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

use CALCDATE('<+' + recJobQueueEntry."Parameter Value 1" + 'D>', WORKDATE) if you want set a variable day diff or

CALCDATE('<+30D>', WORKDATE) for a fix day diff of + 30 days.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi I've used this code

IF recItem.FINDSET(FALSE, FALSE) THEN REPEAT

IF (recItem."Coshh Review Date" >= CALCDATE('<' + recJobQueueEntry."Parameter Value 1" + 'D>', WORKDATE) ) THEN BEGIN

However this now doesn't work for dates within 30 days, only dates above 30 days.. What should I change?

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

if possible send parameter as -30

or use (-1* recJobQueueEntry."Parameter Value 1") in above code.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks, however it has created this error which I can't seem tor resolve. Inputting -30 Isn't allowed.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

seems Parameter Value 1 is text type variable.

can you change it to integer as it represents days

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Use FORMAT((-1* intDate))

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks for the help!

I've set a date to 23/03/2017 which shouldn't be accepted but it still is.

Was this reply helpful? Yes No