topic Re: Calculate date from time field in App Development

Calculate date from time field

valnod_90 — Tue, 02 Oct 2018 07:39:16 GMT

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 — Tue, 02 Oct 2018 14:45:26 GMT

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 — Wed, 03 Oct 2018 09:34:16 GMT

It works!

thank you