date difference in data load editor script

[nroy12]

Hi All,

why in the data load editor i am getting error on for date difference  in days?

i tried

Ceil(Interval(Date#(PQC_earliest_approval_date, 'MM/DD/YYYY') - Date#(firstloaddate, 'MM/DD/YYYY'), 'DD' )) as qc_duration 

i tried all possible combination of the above.

i just want difference in days from PQC_earliest_approval_date and firstloaddate.

Please help.

thanks,

[stevejoyce]

What error are you getting?