Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I want to see the difference in days between two dates. They are formated as ex 2008-03-18 00:00:00 and I have set the the numberformating to YYYY-MM-DD hh:mm:ss, when I use teh expression first.date-second.date it is not working. What to do?
/J
Hi,
please see the attached example.
Are you sure that your dates are interpreted as numbers and not as characters?
Good luck!
Rainer
Hello
I have got the comparison to work but I am having troubles with counting the numer of items orders that have a difference in time.
count(if(date#([Leveransprecision.Bokat datum]-[Leveransprecision.Lovat leveransdatum],'DD')<>0), Leveransprec_KEY)
Something is wrong but I don't know what. And instead of Leveransprec_KEY I could use just "1" cause I want to increase the number by one when there is a difference
Thanks in advance
/J
Hi,
please upload a short example (*.qvw).
Than it´s much more easier to find a solution.
Thank you!
Rainer