Treating a date differently??

[EmmaJane]

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

 

[Rich]

Iif([MyDate]>Date(),Date()<[MyDate])

 

[EmmaJane]

cheers

 

[Mile-O]

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...

 

[EmmaJane]

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

 

[Mile-O]

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?

 

[EmmaJane]

Nope

 

[Mile-O]

Just guessing...

 

[EmmaJane]

Could tell you but it would probably make no sense

 

[Mile-O]

Something student based...bar/restaurant/hotel chain?

 

[EmmaJane]

nope

 

[Mile-O]

Voluntary?

 

[EmmaJane]

Nope, give up you will never get it

 

[Tay]

Must be the NHS then.

 

[EmmaJane]

Differently not the NHS!

 

[Mile-O]

I do give up. So, what industry can have such an attrition level?

 

[EmmaJane]

As explain earlier it would make no sense without a long explanation and I dont type that fast

 

[Mile-O]

Boo! Cop out! Boo! Jeer!

 

[EmmaJane]

See now I’m curious about what you do that gives the time to send so many replies ??

 

[Mile-O]

See now I’m curious about what you do that gives the time to send so many replies ??

Private Medical