ho to subtract a fixed time from a DateAndTime column

Hi Everyone,

I have a DateAndTime column which I need to convert to local time by subtracting 10.5 hrs.
If a record has “22.Aug.208 10:30:00” as a value the I want it as “22.Aug.208 00:00:00”
How can I achieve that

With the date and time shift node :slight_smile:

And if you want to know more about all those date and time nodes, I once wrote a blog post about this.

Cheers, Iris

1 Like