To subtract 5 and a half hours from datefield

[rushabh_shah]

Hi,

I have a date field in my database with timestamp. Example "2017-01-27 14:30:35"

If i want to subtract 5 and a half hours from this field then how can we do it??

Regards,

Rushabh

[DataBlender · Accepted solution]

Hi @rushabh_shah

You can use the function DateTimeAdd . I don't think you can do 5.5 hours in one go, so in the example workflow I have two formulae which first minus 5 hours and then minus 30minutes.

[r4upadhye]

Using a nested loop you can substract: days, hours, minutes, seconds... all in one shot.