Values from field from recent dates (past 30 days)

[vgadang1]

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

[Chanty4u]

Try this .

=Sum({<Lastupdateddate={">=$(=Date(AddMonths(Today(), -1), 'YYYY-MM-DD'))<=$(=Date(Today(), 'YYYY-MM-DD'))"}>} Narrative)

[vgadang1]

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