greater than condition for select in field action (Date field)

[Anonymous]

Hi,

I am trying to set a action for date field, it is working fine if i give the direct value but it is not working with greater than symbol.

So how do can make the above to work?

[antoniotiman · Accepted solution]

Hi,

Try

='>'&Date($(=Today()-7))

Regards,

Antonio

[Anil_Babu_Samineni]

Seems, You have Number format and Today() returns the Date Format as always. Can you cross check the same

[Anonymous]

Hi

Check the Date Format once

[Kushal_Chawda]

try this expression

='(' & concat( distinct if([Lead Created Date]>= today()-7,chr(39)&[Lead Created Date]&chr(39)),',') & ')'

[Anonymous]

Thank you very much Antonio Mancini..

It worked as expected.