date field

[gaspar]

Help me with field on form that give as a result defference between two date fields, in format yy/mm/dd. (exemple: field result is defference between TODAYDATEfield and DATEHIREDfield).

 

[vangogh228]

Create a data control called "Difference", for example, and then:

=[TODAYDATE]-[DATEHIRED]

Format in properties.

 

[gaspar]

It's not that simple...That NOT works!

 

[Geoff Codd]

are the dates stored as date fields or are they text fields

 

[gaspar]

As a date fields. With DATEREFF... I get number of days between two date fields, but I want that in format yy/mm/dd or else...

 

[Geoff Codd]

use the dateadd function combined with the format function to convert dd/mm/yy to yy/mm/dd

[This message has been edited by Geoff Codd (edited 04-23-2002).]

 

[gaspar]

can you write sintax for that:diference between two date fields (in format short date) and result in the same format!!!

 

[gaspar]

I know that, and all date functions such as dateadd,datediff and others.
But,I repeat question:
I have 3 fields on form, 1st and 2nd are date fields in format mm/dd/yy.
Last field must be result as defference between 1st and 2nd field in the same format!!!

 

[Fornatian]

What are trying to achieve? I am not criticising I would like to know the possible benefit of displaying a number as a date, for instance if 4 were the difference, and you say you want it in a short date format, the result would be 03/01/1900.
(following the instructions from the first response)

Ian

PS. If you are frustrated it probably means you haven't asked the right question.