Text box actions

[kevbrown]

I have a text box that has actions. I want the box to make a date selection of yesterday when selected but it doesn't seem to work. My field is Date, and the Search String I'm trying it Today()-1 but it's not working

[Chanty4u · Accepted solution]

try ths

=Date(Today()-1)

[kevbrown]

Easy as that, thank you

[Chanty4u]

chk this

[Chanty4u]

Cool it worked.