How to filter Flow Field in range of date

(0) Share

Report

Posted on by Muaaz Deyab

i want to get the number of invoices that are posted this month. so i created flow field but I can not figure out how to apply the date filter.

I tried to create flow filter field and on open page I tried this

Evaluate(rec."Date Filter", Format(CalcDate('CM', Today)) + '..' + Format(CalcDate('CM-1D+1M', Today)));

but it only give the last date, I also tried to create two flow filters one for starting date and the other for ending date but how can I apply them on the calcFolrmula

it gives error when I write it like this CalcFormula = count("Sales invoice Header" where("Posting Date" = filter(> field("Date Filter"))));

Is there any way I can achieve this using flowField;

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to filter Flow Field in range of date

what about

Rec.SetFilter("Date Filter", '%1..%2', CalcDate('<CM>', WorkDate()), CalcDate('<CM-1D+1M>', WorkDate()));

Was this reply helpful? Yes No