Traffic Light Format for Dates

[Ben_Rix]

Hi Everyone,

Im looking at trying to create a traffic light format rule for scheduled sessions in my app.

Today or in the future = Green | [Latest Session] >= TODAY()
I week in the past = Yellow | [Latest Session] < TODAY() - 7
Older than one week but not including the previous week = Red | I cant seem to get this one to work It keeps overriding the previous rule.

Does anyone have any suggestions?

[MultiTech]

Ben_Rix:

Older than one week but not including the previous week

So not -7 but -14???

[Latest Session] < TODAY() - 14

---

Format rules are applied from the bottom up - meaning:

I would put your red one at the top of the list (making it the last thing to be applied) and your others below that - meaning they are applied first.

[Ben_Rix]

Hey Thanks for that, that seems to do the job, the date that is older than one week has both yellow and red. Not a massive issue but is there no stop if true that can be applied so that it will only display the red tick on those older dates.

[MultiTech]

Ah, you’ll need to apply two date limits for that middle condition:

and(
  [Latest Session] < today(), 
  [Latest Session] >= today() - 7
)

If you think about the original statement for the yellow condition, you simply said it needs to be less than 7 days old - that includes something 1,543 days old.

[Ben_Rix]

MultiTech_Visions:

and(
  [Latest Session] < today(), 
  [Latest Session] >= today() - 7
)

Ohhhh thanks so much for that. I think i might be on this forum quite a bit. I Really appreciate your help.

[MultiTech]

@Ben_Rix You’re welcome

[Lucinda_Mason]

This forum has been a lifesaver for me the past 10 months or so.