adam spencer (3/22/2011)

---

The year needs to be 2010 but under these conditions.

here is what I have

where DOS =

CASE 2011

WHEN AD.DM_ConfirmationID = 2 --Agreed

THEN year(isnull(AE.AE_PatientEncounterDate, AD.AD_Date))= 2011

WHEN AD.DM_ConfirmationID...

Steve, this sounds like a great idea! There is a languish/anticipatory switch. Ofcourse if it's not in the budget, then maybe we could get the just the last...

I feel your pain, it's so hard to upgrade. Well depending on your version you might have ticker tape, foil, or even a card deck.

Failing all that,...

8" SINGLE - SIDED FLOPPIES - NOW THERE'S A TIMEWARP hehe:

I don't get the same hour, but the same date, minute, and seconds

The hour could not match since my local time is not GMT, (GMT+8).

My results:

2009-11-16 09:02:17.020 Monday

2009-11-16 09:02:17.020 Monday

2009-11-16...

Ths link is wrong - should be http://www.ssmstoolSpack.com (tools is plural) - otherwise you go to bogus page

Hi Steve,

I feel your pain.  You offer some great advice, your counsel of 'don't panic, and make a plan' is probably the most useful. No point of compounding the problem.  But...