Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nroy12
Contributor II
Contributor II

date difference in data load editor script

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,

Labels (3)
1 Reply
stevejoyce
Specialist II
Specialist II

What error are you getting?