How to calculate date difference from one date to 30 days before Todays date

[bvssudhakar]

Hello Experts,

Can you help me for this query..:=Sum({<Floor(Today()-30)-Floor([Closed date])>}[No. of CV Submitted])

I wrote this expression for bar chart but it is giving error

My requirement is i want to calculate date difference from closed date to last 30 days for resumes submitted column

Please help me out from this

swuehl stalwar1‌mbaeyens‌ jagan

Thank you in advance

[sunny_talwar]

Are you looking for date difference or are you counting/summing the number of cv submitted here? What is the goal?

[bvssudhakar]

Hi Sunny

I want to show how many resumes submitted between closed date column to 30 days before today

[sunny_talwar]

In that case... try this

=Sum({<[Closed date] = {"$(='>=' & Date(Today()-30))"}>} [No. of CV Submitted])

[bvssudhakar]

that means i want to sum of resumes submitted between those two dates

[Anil_Babu_Samineni]

I think, This is what you are stating. Can you check this?

=Sum({<[Closed date] = {">=$(=Date(Max([Closed date])-30))<=Max([Closed date])"}>} [No. of CV Submitted])

[bvssudhakar]

It's not giving any data, it is showing no records to display

[sunny_talwar]

What is the format for Closed date? Is it a date or timestamp field?

[bvssudhakar]

Hi Anil,

This is also not showing any result, I want to show the sum of resumes submitted between closed date column to 30 days before today's date

[bvssudhakar]

I have taken the data from sql server and i think that column data type is varchar