Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF statement for dates

Good morning   I have a table with a Start Date/Time column and and End Date/Time column. There is also a Period Start Date/Time and Period End Date/Time columns. I want to try and add another colu...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    v-piga-msft 

     

    I have solved it

     

    In Production = IF([UTC_END_TIME] > [Start Of Period Date/Time] && [UTC_START_TIME] < [End Of Period Date/Time], "YES", "NO")
     
    Thanks for your time
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

I still have a little confused about your logic.

It seems that the result is correct based on your logic.

1/1/2019 4:15:00 is not between  01/01/2019 05.00:00  and 01/01/2019 05.59:59 and 01/01/2019 06.15:00 is not between 01/01/2019 05.00:00  and 01/01/2019 05.59:59 either.

If it is convenient, could you describe your logic in more details so that we could help further on it?

Best  Regards,

Cherry

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Cherry

     

    Thanks for getting back to me.

     

    I want to show in running. Start is 04:15, So that populates the 4:00:00 - 4:59:59 with Yes, the "Event" is still in running between 5:00:00 and 5:59:59. So that populates 5:00:00 and 5:59:59 with Yes. The End Date/Time is 6:15:00 so that populates 6:00:00 - 6:59:59 with Yes

     

    I hope that explains properly

     

    Thanks again

    Joe

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-piga-msft 

       

      I have solved it

       

      In Production = IF([UTC_END_TIME] > [Start Of Period Date/Time] && [UTC_START_TIME] < [End Of Period Date/Time], "YES", "NO")
       
      Thanks for your time