Skip to Content

Formula to change date value by compare the date

Jan 18, 2017 at 09:27 PM


avatar image
Former Member

Hi community,

I've a simple question. Could you please to help me with a suitable fomula for the next task.

I've a date value in my report such as 12.01.2017 14:09

I would to campare the date like: If [MyDate] is between 00:00:00 and 19:00:00 then [MyDate]+4 hours ElseIf [MyDate] is between 19:00:00 and 23:59:00 then [MyDate]+2hours

Which kind formula could be possible for my task ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers