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.
