Treating a date differently??

EmmaJane

Registered User.
Local time
Today, 14:03
Joined
Nov 5, 2003
Messages
214
I have a report based on a query that gives me the length of service of our employees grouped by month, however my problem is that it is partly based on an end date but if the employee is still with us they will have a default date of 31/12/04. What I would like to do if possible is treat this date as now() if is beyond the date of running this report.

If anyone could point me in the right direction I would be grateful

Emma
 
cheers
 
Why don't you change the default value of the date field as it's too close? I use 31/12/2200 for expiry dates...of people, of products, of anything.

Then, run an UPDATE query to change all records in the date field with the default of 31/12/2004 to a date way, way in the future...
 
We have a high turnover of staff and a lot we have now will not be here by the end of next year! At the end of this year it gets moved again to 2005.

Also my tables are linked in from other system so I'm not sure about running an update query, but thanks
 
EmmaJane said:
We have a high turnover of staff and a lot we have now will not be here by the end of next year!

Call centre?
 
Could tell you but it would probably make no sense:)
 
Something student based...bar/restaurant/hotel chain?
 
I do give up. So, what industry can have such an attrition level?
 
As explain earlier it would make no sense without a long explanation and I dont type that fast :D
 
See now I’m curious about what you do that gives the time to send so many replies ??
 
EmmaJane said:
See now I’m curious about what you do that gives the time to send so many replies ??

Private Medical
 

Users who are viewing this thread

Back
Top Bottom