Using Today()-30

[navaneeth79]

Hi all,

I am using if(Submit_Date <= Today()-30,Submit_Date)

I am not getting the values 30 days and older records in the table but  its displaying all available records. I want only 30 days or older records.

[its_anandrjs]

Try this use Date to convert numeric date

if(Submit_Date <= Date( Today()-30 ),Submit_Date)

[sunny_talwar · Accepted solution]

Have you added all the dimensions/fields you need to see in the chart? And also, select 'Suppress When Value Is Null' for the above dimension on the dimension tab?

[navaneeth79]

I have added all the required dimensions

[sunny_talwar]

and what happened?

[navaneeth79]

if condition not reflecting in the chart

[sunny_talwar]

Would you be able to post a sample or an image to show what you are seeing?