Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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
Partner - Master

Try

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