Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Change Date SI_STARTTIME Variable to yyyymmddhhmmss
- Thread starter levette
- Start date
Currentdate-1 should give you yesterday's machine date. There is also a DateAdd function, but days are assumed as a default.
If you put this in a formula field, it can then be displayed in any format you like. ToText allows fancy date formatting, or right-click and format field.
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
If you put this in a formula field, it can then be displayed in any format you like. ToText allows fancy date formatting, or right-click and format field.
Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 - Status
Similar threads
- Locked
- Question
- Locked
- Question