Flowfield to see the birthday is this week?

slmaluwa
slmaluwa Member Posts: 366
in NAV Three Tier
On a cue table, I want to create a flowfield with the count of Employees celebrating the birthday within the next seven days. Is this possible?
I created a function/procedure to pass the Birth Date field from Employee table and see whether the this year birth day falls between today(0 and Next 7 days.

how can bring it to a Cue table, please ?
"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."

Answers

  • DenSter
    DenSter Member Posts: 8,307
    Not sure if it works but try creating a FlowFilter field in the Cue table, and then a cue field that counts the employees based on where the Birthday field is filtered by the flowfilter. You would then have some logic in OnOpenPage event of the cue stack to set the value of the flowfilter to the next 7 days
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories