Re: [Bulk] RE: Object Last Use Date MDY compare issue

Paul:

Hmm...

I suppose you could always do something like an ALTER TABLE to add a new column, to store your Last Used Date in the format you want, e.g. with the century included -- you could even convert to YYYYMMDD, for example. FIrst, you do the ALTER TABLE to add the new column, then you run an SQL update ... where ... similar to what I posted previously, to populate the new column with whatever data you want, in whatever format you want.

Does that "make sense"?

All the best,

Mark S. Waterbury

> On 2/11/2015 3:22 PM, Steinmetz, Paul wrote:

Mark,

Yes, that helps a lot.
I still need the century concatenated when comparing LUD.

Paul