Forum Discussion
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...
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
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
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