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: 
abc_18
Creator II
Creator II

How to calculate # no of days

Hi,

I need to calculate a field called #days in Backorder.

field Order date is skey_date_order


So I can calculate the difference with today’s date, please suggest how can I achieve this?

Thanks

2 Replies
petter
Partner - Champion III
Partner - Champion III

Today()-skey_date_order

thevingo
Creator
Creator

Hi

try   Date#(Today(), 'DD/MM/YYYY') - Date#(skey_date_order , 'DD/MM/YYYY')

format DD/MM/YYYY depend on date format of field skey_date_order

You may have to change this.