Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i need a butten to chose date feild before today ?
i wrote =<today().... but nothing heppend.
what i need to write ?
thanks'
yarin.
If you mean all dates less than today:
='<' & today()
If you mean yesterday:
=date(today()-1)
Try
=FirstWorkDate(today(), 2)
If you mean all dates less than today:
='<' & today()
If you mean yesterday:
=date(today()-1)