Date filter to calculate last 30 days data

[Dilip_Adiga]

Hi Guys,

I have got a table which has Invoice value and Date. I know how to get This Month, This year and Date Range values by putting in a Choice value. I need to know how can I get

Last 30 Days — Based on Now

I am using Now Date as baseline.

Could someone help me out with formula to calculate last 30 days based on Now Date?

Thank you guys in advance,

Regards,
Dilip

[Darren_Murphy]

Create a Math column using the formula Now-30, where Now is the current date/time.
This will give you the date 30 days ago.

[Dilip_Adiga]

Now can be a date like 5 Feb 2024?

Or should it be converted to integer?

Regards,
Dilip

[Dilip_Adiga]

Thank you Darren as always

[ThinhDinh]

Now is a value that you can reference in a math column.

[Dilip_Adiga]

Thank you ThinhDinh, I had got the solution working.