Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am working on a table to bring messages from a field called "Narrative", and I want to limit the messages from the past 30 days for which I have a date column "Lastupdateddate".
Appreciate any help I can get here.
Thanks,
VG
Try this .
=Sum({<Lastupdateddate={">=$(=Date(AddMonths(Today(), -1), 'YYYY-MM-DD'))<=$(=Date(Today(), 'YYYY-MM-DD'))"}>} Narrative)
Thank you! I think it is working, except that I realized my date column's max date is Oct 2022,
so I changed the code slightly
=aggr(Sum({<dtg={">=$(=Date(Max(DATE), -1), 'YYYY-MM-DD'))<=$(=Date(Max(DATE), 'YYYY-MM-DD'))"}>} [narrative]), [narrative])
It didnt work, what am I doing wrong?
Thanks,
Vidya