Adding Date

[praveenkumar_s]

I have one field as Date of joining..Now i want to add that date with current date to calculate Experience..how do i do that..let me know anybody...thanks..

[Miguel_Angel_Baeyens]

Praveen,

If I understand you right, this should work in the script:

LOAD *

, Today() AS CurrentDate

, JoinDate - Today() AS DaysInPosition

FROM File.qvd (qvd);

Miguel