F Fly Boy 5 Apr 21, 2009 #1 I have a field called Date_Fm and another Date_To for vacation dates. I need to calculate days. I appreciate your help!
I have a field called Date_Fm and another Date_To for vacation dates. I need to calculate days. I appreciate your help!
G golfinray Apr 21, 2009 #2 In a query, Datediff("d",[date_fm],[date_to]) In a form, =Datediff("d",[date_fm],[date_to])
F Fly Boy 5 Apr 21, 2009 #3 Worked like a champ! Thanks, golfinray said: In a query, Datediff("d",[date_fm],[date_to]) In a form, =Datediff("d",[date_fm],[date_to]) -- Milton Purdy ACCESS State of Arkansas Fly Boy 5 said: I have a field called Date_Fm and another Date_To for vacation dates. I need to calculate days. I appreciate your help! Click to expand... Click to expand...
Worked like a champ! Thanks, golfinray said: In a query, Datediff("d",[date_fm],[date_to]) In a form, =Datediff("d",[date_fm],[date_to]) -- Milton Purdy ACCESS State of Arkansas Fly Boy 5 said: I have a field called Date_Fm and another Date_To for vacation dates. I need to calculate days. I appreciate your help! Click to expand... Click to expand...
