I am struggling in my current doc (import from excel) to fin the difference between two dates. i have this working fine in 1 doc
However, when i transpose this to another doc and change fields it returns null -
here is the transposed code:
The format of the date for both fields being imported from excel is like so 7/6/2016 12:00:00 AM
I am really struggling to see the difference and why this is not working:
here is the load SET
SET TimestampFormat='MM/DD/YYYY hh:mm:ss[.fff]';
and the sheet it is being loaded from
LOAD TEST_Order_No as [Order Reference],
//[Suplier Name] as [Supplier Name],
Date_Order as [Date Ordered],
locationCode as [TEST Location],
[Item No.] as [TEST ITem Ref],
Thank you so much, i really hope you can help with this.....So annoying as i had it working before.
Solved! Go to Solution.
I have just tried this and it returns a dash
Interval(Date_Imported - [Date Ordered],'D')
Thank you for the reply..... Any idea what i am doing wrong here?
Thank you so much for the reply but this returns error in expression :
date((date#(Date_Imported,'MM/DD/YYY')- date(Date#([Date Ordered],'MM/DD/YYYY')),'DD'))*1