Timestamp interval problem

[mikegrattan]

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.

[richardm90]

Thanks again

[sunny_talwar]

I can barely see the screenshot, let alone the expression you have used....

[richardm90]

Apologies....

[sunny_talwar]

Might be because of rounding issues... try this

If(Expression > MakeTime(0, 29, 59) and Expression < MakeTime(0, 30, 1), 'Basic')

[richardm90]

Perfect! Thank you very much