Hello...
This maybe easy but it has me stumped.
I need to find out how many days are between two dates.
(Ie.)
Jan 31 2004 and Jan 1 2004
The results I am getting are not accurate.
What I am trying to do is this:
I have report that pulls info from a query. There is a sales period date and an employee start date. I need to findout how many days there are since the employee has started and the sales period.
I currently have an unbound text box on my report that simply takes the period date and subtracts the employee starting date....(that does not seem to work)
=Sum([Period_Date] - [Employee_Statring_Date])
Make sense? Any help or direction would be appreciated.
Peter
This maybe easy but it has me stumped.
I need to find out how many days are between two dates.
(Ie.)
Jan 31 2004 and Jan 1 2004
The results I am getting are not accurate.
What I am trying to do is this:
I have report that pulls info from a query. There is a sales period date and an employee start date. I need to findout how many days there are since the employee has started and the sales period.
I currently have an unbound text box on my report that simply takes the period date and subtracts the employee starting date....(that does not seem to work)
=Sum([Period_Date] - [Employee_Statring_Date])
Make sense? Any help or direction would be appreciated.
Peter
