Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to use the Interval function to get the difference in minutes between two timestamps, but the result is in error. Here's the function I'm using in my load script:
Interval(TimeStamp#(TimeStamp(EndLoadTimestamp, 'M/D/YYYY h:mm:ss'), 'M/D/YYYY h:mm:ss') - TimeStamp#(TimeStamp(BeginLoadTimestamp, 'M/D/YYYY h:mm:ss'), 'M/D/YYYY h:mm:ss'), 'm') as MinutesToLoad
Here's what the results look like:
Month(Date) | OrderType | SalesOrder | BeginLoadTimestamp | EndLoadTimestamp | MinutesToLoad |
May | SO | 21169443 | 5/30/2018 8:55:37 | 5/30/2018 8:58:12 | 0.00 |
May | SO | 21169414 | 5/30/2018 7:33:36 | 5/30/2018 7:33:37 | 0.00 |
May | SO | 21169344 | 5/30/2018 2:18:39 | 5/30/2018 2:19:26 | 0.00 |
May | SO | 21169342 | 5/29/2018 18:11:43 | 5/29/2018 18:11:56 | 0.00 |
May | SO | 21169191 | 5/29/2018 12:07:49 | 5/29/2018 12:08:14 | 0.00 |
May | SO | 21169175 | 5/29/2018 18:42:19 | 5/29/2018 18:42:19 | 0.00 |
May | SO | 21169139 | 5/29/2018 16:08:04 | 5/29/2018 16:58:59 | 0.04 |
May | SO | 21169123 | 5/29/2018 18:34:41 | 5/29/2018 21:38:01 | 0.13 |
Any ideas on how to get this work correctly?
Thanks.
Thanks again
I can barely see the screenshot, let alone the expression you have used....
Apologies....
Might be because of rounding issues... try this
If(Expression > MakeTime(0, 29, 59) and Expression < MakeTime(0, 30, 1), 'Basic')
Perfect! Thank you very much