create a flag if there is difference between two dates

(0) Share

Report

Posted on by Rupali

335

Hi ,

I have a requirement where I want to flag whenever there is a difference between two dates i.e. Promised Receipt Date and expected receipt date in purchase line Table.

If I need to create a cue on the Role center, How can I compare two dates with Flowfield?

In case I want to I want give an error in Red Line just like there is one for "Overdue sales Items"on Role centre.

Thanks in Advance

All responses (5)

Answers (0)

Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: create a flag if there is difference between two dates

Apply the filter on the Record and then use Rec. Count or you can loop through records and increment the integer.
Rupali 335 on at

Like (0)

Report

RE: create a flag if there is difference between two dates

I need to get the count of items where Promised Rec Date is Less than Expected receipt date in Purchase line table, How can I do that with code?
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: create a flag if there is difference between two dates

I am not sure if I understand, you just do a regular comparison of the fields like If Date1 > Date2 ....
Rupali 335 on at

Like (0)

Report

RE: create a flag if there is difference between two dates

How can we compare two dates in a table?
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: create a flag if there is difference between two dates

Unfortunately, you cannot do this with flowfield you need to calculate that using code and set the flag.