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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Bad_QlikDeveloper99
Contributor
Contributor

Difference between two dates

Hello everyone,

I´d like to get the difference of two dates in days. I tried the Interval-function, but after using it, the result was only '-'.
I am using the following function: 

Interval(V_BelegKopf.Pruefungsdatum - V_BelegKopf.BelegDatum,'D')

Could somebody help me, please?

 

Labels (1)
2 Replies
Vegar
MVP
MVP

It could be that your ...datum fields are not recognised as dates. 

Once you ensured that then your expression  or just num(V_BelegKopf.Pruefungsdatum - V_BelegKopf.BelegDatum, '0') should give you what you want.

BrunPierre
Partner - Master II
Partner - Master II

Try

=Floor(Num(V_BelegKopf.Pruefungsdatum - V_BelegKopf.BelegDatum))