Archive
Highlighted

Search 2 date fields and find amount of days minus weekend days

Explorer

Hello, I need to formulate a search there I have 2 date fields one is STARTTIME 2020-02-28 19:19:58.0 other field is ENDTIME 2020-03-03 19:19:58.0. What I need to do is find out is the STARTTIME is before the weekend and the ENDTIME is after the weekend. And chart my results based on that including other fields. I only want results where the STARTTIME is before the weekend and the ENDTIME is after the weekend. Events where the STARTTIME and the ENDTIME and before or during the weekends can be excluded.

For examples STARTTIME is 2020-02-28 19:19:58.0 but ENDTIME is 2020-02-2919:19:58.0 would not count as it was started and ended during the weekend. I only want events started before and ended after the weekend to count. Any help would be appreciated

Tags (1)
0 Karma
Highlighted

Re: Search 2 date fields and find amount of days minus weekend days

Explorer

I should add, I have to go by STARTTIME and ENDTIME as the standard Time for the event will not be accurate as these events update every 15 minutes so only the STARTTIME and END_TIME fields give accurate times

0 Karma