Changed visibility based on time due

[GrantWoods]

I am trying to make my list in my app change collors based on if the order is due today, tomorrow, or 2 days from now

Here is my changed visility setting but there are not working

[dilon_perera]

Hi @GrantWoods,

You need a Date Property because that property has the is equal to operator!

Then for the Today text you can add the condition as Current Job > Date property > is equal to > current time.

For the Tomorrow text you can add the condition as Current Job > Date property > is equal to > tomorrow from Date options or is after > current time.

For the 2 days text you can add the condition as Current Job > Date property > is equal to > 2 days from now from the Date options or is after > 2 days from now.

Hope I’m correct and Hope I understood the question correctly!

Thank you

[GrantWoods]

Tanks

[GrantWoods]

What about this

where is equal to

[dilon_perera]

That seems like the Date & Time property!

You need the Date property!

[GrantWoods]

i have that but there is no equal to on the list its before after or bettween

[dilon_perera]

Could you show a screenshot of that Due Date property in the database?

[GrantWoods]

[dilon_perera]

Yeah! I see that Due Date is a Date and Time property ( by the little clock icon )!

[GrantWoods]

so the one is due date for the job what is the other data for and do i have to fill it in with any thing

[dilon_perera]

You just need a Date property! If you don’t need time you can delete that Date & Time property!