How to subtract two dates and get an actual number

[erick-flores]

Hello all

I know how to do this in excel but I dont know how to do it in an
Access form. I have two dates inv_date and QueryDate. Both dates are
field in my form. What I want is subtract QueryDate - inv_date and get
the results in days. This is what I tried w/o any luck
=([QueryDate]-[inv_date])

Can somebody help me here please....thanks in advance

 

[John Vinson]

Hello all

I know how to do this in excel but I dont know how to do it in an
Access form. I have two dates inv_date and QueryDate. Both dates are
field in my form. What I want is subtract QueryDate - inv_date and get
the results in days. This is what I tried w/o any luck
=([QueryDate]-[inv_date])

Can somebody help me here please....thanks in advance

Use the DateDiff function:

DateDiff("d", [QueryDate], [inv_date])

John W. Vinson[MVP]

 

[erick-flores]

Thank you very much, that worked perfect.