Subtract seconds

[farolito20]

How subtract one second to a date?

[nagaiank]

You may try the following expression:

Timestamp([Your Date or Timestamp]-Interval#('00:00:01','hh:mm:ss'),'dd/mm/yyyy hh:mm:ss')

[#3]

hi

see attached file.

Timestamp(Timestamp([date1]-Interval#('00:00:01','hh:mm:ss'),'dd/mm/yyyy hh:mm:ss'))

[fdelacal]

try in the list box with this

=timestamp(Timestamp([date1]-Interval#('00:00:01','hh:mm:ss'),'dd/mm/yyyy hh:mm:ss'))

add timestamp..

hope it helps you