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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz_1011
Partner - Creator II
Partner - Creator II

Interest days (Days360; 30/360)

Hi all,

the records i am loading in my script contain a start date and an end date. For every record i need to calculate the total number of interest days between start and end date following the Days360 logic that - for example - exists in Excel (assumption is, that a month consists of 30 days and a full year of 360 days).

Is there anything similar to the Dsys360() function in Qlik or has someone a good tip on how to do this ?

Thsnks a lot in advance!

Labels (1)
1 Reply
HirisH_V7
Master
Master