Within last 7 days

[#1]

I need some text changed to red if the Ideas.CalendarDate is within the last 7 days

I don't think this is right though. Any ideas?

IF(Today()-Ideas.CalendarDate<'8',RGB(255,0,0),)

[rubenmarin · Accepted solution]

Hi Alex, you should remove the last comma, and numbers doesn't need to be between simple quotes:

IF(Today()-Ideas.CalendarDate<8,RGB(255,0,0))

It will only work where there is only one value for Ideas.CalendarDate, if ther are more than one value you'll need some kind of aggregation to return only one value, ie:

IF(Today()-Max(Ideas.CalendarDate)<8,RGB(255,0,0))

[#3]

if(Ideas.CalendarDate >=Date(Today()-7) and Ideas.CalendarDate <=Date(Today()),RGB(255,0,0))