I have a column field which is formatted with Date/Time called LVPROGDATE and another column field formatted with Date/Time called Date To in ACCESS. I want to subtract the LVPROGDATE - DATE To to get the Number of Days of Longevity whihc will be Column 3. Is there a quick way to do this with an expression?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Subtraction 2
- Thread starter md092686
- Start date
-
1
- #2
-
1
- #3
SkipVought
Programmer
Code:
expr: LVPROGDATE - [DATE To]Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
When a diminutive clarvoyant had disappeared from detention, headlines read...Small Medium at Large
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Status
Similar threads
- Question
