Comparison of two dates in query?

[Former Member]

Dear all,

the problem looks quite simple: I have a BANF with a creation date (BADAT) and a FRGDAT. e.g. BADAT = 20.03.2004, FRGDAT = 25.03.2004. Customer wants a field with "5 days"... Can you help how to implement that??? I think it's simple but...

THANK YOU ALL!!!!

All the best,

Angelika

[Former Member]

You need to have those 2 dates as key figures. Create then a formula with the substraction, this should work

Ioan