Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Try
=Floor(Num(V_BelegKopf.Pruefungsdatum - V_BelegKopf.BelegDatum))