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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.