I am creating a GI that gives me service orders that were created on Saturday and Sunday or after 4pm on weekdays. What do I use for filters??? I tried @weekstart+5 and @ week start+6 to get Saturday and Sunday but it doesn’t pull anything.
I don’t even know where to start for the after 4pm on weekdays.
Help!?
Best answer by meganfriesen37
Try using the Day of Week and Hour functions on the FSServiceOrder.CreatedDateTime field as shown below:
I think you might need to play around a bit with the hour value, since my system is in EST (and I’m in MST), so I’d expect created hour should be 13 based on what I see in the Audit history, but it’s showing as 20, so I’m wondering if there’s some time zone conversion going on. Using the Day of Week function Sunday is day “1” and Saturday is day “7”
+12Try using the Day of Week and Hour functions on the FSServiceOrder.CreatedDateTime field as shown below:
I think you might need to play around a bit with the hour value, since my system is in EST (and I’m in MST), so I’d expect created hour should be 13 based on what I see in the Audit history, but it’s showing as 20, so I’m wondering if there’s some time zone conversion going on. Using the Day of Week function Sunday is day “1” and Saturday is day “7”
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
