cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
christianyepez2 Regular Visitor
Regular Visitor

Add Conditions for Date/ Time (time intelligence funtions)

Hello 

 

I need a calculated colum for these conditions, and my formula doesn´t work

 

I have a table whit the first 3 columns, I want to calculate the last one: wich is based on the conditions in the second one,

The conditions are

if( cod = 1010 && hour =12; nextday(Hourdate))

if( cod = 1011 && hour =19; nextday(Hourdate))

if( cod = 1012 && hour =12; nextday(Hourdate))

 sss.PNG

 

 

Please someone help me 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Add Conditions for Date/ Time (time intelligence funtions)

I would just use "[HOURDATE] + 1" instead of NEXTDAY function honestly.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Super User
Super User

Re: Add Conditions for Date/ Time (time intelligence funtions)

I would just use "[HOURDATE] + 1" instead of NEXTDAY function honestly.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!