Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys, I need to calculate days in a column of dates for example :-
10/01/2012
31/03/2012
05/04/2012 etc.
The problem I have is that in the QVD I load, all the dates in the same column have the same field name. How do I calculate the number of days between the two different dates in this instance.
Paul.
[test]:
LOAD * INLINE [
F1
10/01/2012
31/03/2012
05/04/2012
];
[test2]:
LOAD
F1
,previous(F1) as PF1
,date#(F1, 'DD/MM/YYYY') - Date#(Previous(F1), 'DD/MM/YYYY') as F2
Resident [test];
make sure you order them correctly during load