Share
Report
29i 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;
All responses (
Answers (
