Add a second to time

[system]

I have an issue I am trying to have a variable where two dates match, however one is always 1 second before. How do I add a single second to a date/time field?

Thanks.

---

ScottRVA (BOB member since 2011-10-21)

[system]

Hi,

I suggested in this old topic:

Changing the time portion of timestamp

Hi I just wanted to add an hour with my existing timestamp, your input is more appreciated. I wanted to do this only on the Report and not on the universe. Say the time in the column 14-08-2009 14:30:00, i wanted to display it as 14-08-2009 15:30:00 Regards Siva.M looksmee (BOB member since 2006-02-08)

a formula that adds 1 hour to a date in DeskI. Maybe it will get you started although the formula is not nice at all.

---

Marek Chladny (BOB member since 2003-11-27)