DSXchange

Looks like we need to chat about dates. For the record, "2015-11-20" is not a date, it is a string formatted in the external representation of a date. An actual DATE field has no format and is basically stored internally as a large number, the number of offset days from a certain zero date...

Or that.

"Reworked fix for previous issue to avoid unexpected side-effect"

I hate those.

True... forgot to mention that... possibly depending on what else is in the string.

I know you are appending zeroes, the 'think' part was as to the validity of the date as in are you appending them to a valid date? We'd need to see your "IsValid" logic to check out that part of the puzzle...

Sounds like you are going 'the wrong direction' with the link.

Ah, never mind. "I have a text file" so there's no actual CLOB involved, just a string field with that name. You really need to supply more information so we don't have to guess at some of these answers. For example, you mention "first row" and "last row"... what happen...

Database?

Welcome. Not sure why people would be storing small strings in a CLOB field, is there more to it than that or is that literally the entire contents? I'd also be curious what requirements you were given, any direction on how to accomplish this. What database are we talking about? They typically come ...

Fix your issue? You may think you are appending that zero time to a date but the error message says you are not, so I would ensure your dates are always valid before you add the time as all it takes is one bad apple to cause that message. If you are sure everything you are doing is fine, contact sup...

It's in my previous reply in this thread.

So check with support.

Sure. Let's say that.

You're not able to create the link at all? Or something else?

I never got a chance to be awesome.

Still not clear... if it needs to be a job parameter so it can be "used in other stages" who/what is responsible for fetching or setting the value? Does "other stages" mean in a Sequence job? Other stages in a PX job? And what in the heck does this have to do with the script? :? ...