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]

one list box with both open and close fields? How did you do that?

[bvssudhakar]

Ok i will try this with alternate states..

Creating Master Date Column for different date columns in a table

Please give me some possible solutions for this thread question.... i am very much eagerly waiting for this