Hi,
I have a continuous form based on a query ( I will also be creating a
report based on the same query).
There are 2 fields:
Date Obtained and Date Of Expiry
I want a further 3 columns to the right of these 2 fields to show the
number of Years, Months and Days between the 2 given dates.
In the query I have the dates as the first 2 columns. In the third
column I have:
Column 3 Has - Years: DateDiff("yyyy",[DateObtained],[DateOfExpiry])
Column 4 Has - Months: DateDiff("m",[DateObtained],[DateOfExpiry])
Column 5 Has - Days:
DateDiff("d",DateAdd("m",[Months],[DateObtained]),[DateOfExpiry])
However my data is not coming out quite how I would like it, for
example
Date Obtained Date Of Expiry Years Months Days
14/06/05 14/06/06 1 12 0
30/06/05 03/08/05 1 2 -27
On the first example I just want it to show: 1 0 0
On the second I want it to show: 0 1 3
I hope this makes sense and hope someone can help me out here.
Please make any recommended solutions as clear as possible.
Thanks in advance to anyone who takes the time to help me out here.
Regards.