This content has been marked as final. Show 4 replies
I have q query with the date# function
DATE_1 = 20150904
DATE_2 = 20160711
Date#(DATE_1,'YYYYMMDD')-Date#(DATE_2,'YYYYMMDD') = output value is shown as -329 .
But when we do it manually :20150904 – 20160711 = -9807 .
Can any once please tell how -329 is coming.
Thanks in Advance!