Skip to main content
Microsoft Dynamics NAV forum
Suggested answer

create a flag if there is difference between two dates

editSubscribe (0) ShareShare
ReportReport
Posted on by 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

Attachments
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,636 on at
    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  Profile Picture
    Rupali 335 on at
    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 Profile Picture
    Suresh Kulla 43,636 on at
    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  Profile Picture
    Rupali 335 on at
    RE: create a flag if there is difference between two dates

    How can we compare two dates in a table?

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,636 on at
    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.

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,080 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,601 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans