Calculate date from time field

[valnod_90]

Hello everyone,

i'm not sure that i am in the right section of the forum but i have a question for you and i really hope you could help me.

I have two saparated fields: "Date" and "Time", that are correlated with each other.

I need to subtract 26 hours from the field "Time" and then extract the new date.

For example:

Starting Date: 2/10/2018

Starting Time: 8:00:00

If i subtract 26 hours the new time will be 6:00:00 but i need to know even the new date.

How can i do it?

Thank you!

[sunny_talwar · Accepted solution]

May be try this

Time(Frac([Starting Date] + [Starting Time] - 26/24)) as [New Start Time],

Date(Floor([Starting Date] + [Starting Time] - 26/24)) as [New Start Date],

[valnod_90]

It works!

thank you