If Date equals to today() then change background color

[renjithpl]

Hi All,

I have a date field and when any of the date equals today(), the the background color should change in my straight table.

i have tried something like this, but no output.

=if(DateRecieved=Date(today(), 'MM-DD-YYYY'), RGB(80, 240, 60))

Regards

Renjith

[its_anandrjs]

Hi,

You need to put this code

=If(DateRecieved = today() ,RGB(80, 240, 60))

in the Background option of the straight table then you abe to check it want to know that where you put this code, please confirm it.

Regards

Anand

[SunilChauhan]

please see the attcahed file

[its_anandrjs]

Hi,

See the sample file to clear the fuctionality of background color by the code

=If(Date=Date(Today(),'MM-DD-YYYY'),RGB(80, 240, 60))

See the attached sample file.

Regards

Anand

[renjithpl]

hi Anand,

Please look in to my attached applilcation, its in the first thread.

Regards

Ranjith

[kaushiknsolanki]

Hi,

    Put this expression in background color

    If(floor(DateRecieved)=Today(),RGB(80, 240, 60))

Regards,

Kaushik Solanki

[its_anandrjs · Accepted solution]

Hi,

Yes Right but it is strange, you need to put the

Floor(DateRecieved) in place of DateRecieved beacaue the field is different and you need to get

to the nearest multiple of base of the field then you get the correct result as kaushik says.

See the attached sample file.

Regards

Anand