We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

To subtract 5 and a half hours from datefield

rushabh_shah
8 - Asteroid

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

2 REPLIES 2
DataBlender
11 - Bolide

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
11 - Bolide

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

Labels