Timestamp - 24 hours

I am trying to get a date time field to be set by button to 24 hours prior to current time.
any help?

- Alain_Fontaine
- 3 yrs ago
- Reported - view
'Date / Time' := now() + 86400000

The magic number is the number of millisecondes in a day.
- Alain_Fontaine
- 3 yrs ago
- Reported - view
You said "prior"… Replace "+" by "-".
- Ppc
- titanium_fish
- 3 yrs ago
- Reported - view
- Ppc
- titanium_fish
- 3 yrs ago
- Reported - view
it seems not to let minus a timestamp
- Ppc
- titanium_fish
- 3 yrs ago
- Reported - view
it will allow + but not -
- Ninox partner
- RoSoft_Steven.1
- 3 yrs ago
- Reported - view
datetime(number(now()) - 86400000)

Steven
- Alain_Fontaine
- 3 yrs ago
- Reported - view
"+" works, but not "-"… Ninox is an inexhaustible source of fun. And just to enjoy the funny side of life, this works:

let d := -86400000;
'Date / Time' := now() + d

Steven's formula is of course more reasonable.

Content aside