Forum Discussion

ggzmorsh's avatar
ggzmorsh
Helper II
6 years ago
Solved

IF statement for time

I need an IF statement where if a specific column has a Date and Hour it would get me the Final Date by checking a separate hour table or a condition that if the Hour is between 00:00:00 and 08:00:00...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi ggzmorsh 

    try 

    Final Time = IF([Hour] < TIME(8,0,0),Date1 - 1,Date1)

    or

    Final Time = IF(TIME(VALUE(LEFT([Hour],2)),00,00) < TIME(8,0,0),Date1 - 1,Date1)

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

ggzmorsh's avatar
ggzmorsh
Helper II
6 years ago

I forgot to mention this:

Final Time = IF([Hour] < TIME(8,0,0),Date1 - 1,Date1)

When i used this formula earlier it would always return as true. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I used this:

 

FinalTime = IF('Table'[HOUR] < TIME(8;0;0);'Table'[DATE1]-1;'Table'[DATE1])
 
It works:
 
Please note that Month and Day are switched in date fields, because i use a different Locale. Thus this is calculated 1 day back from the 1st of may.