Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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))