DSXchange

Hi to everyone,
is there a way to check if an input is a date in a transformer stage?

tks

IsValidDate()

Doesn't quite relate to your subject, though.

Only if the source data type is a string of some kind.

If the source data type is Date, then theoretically it can't be invalid unless it has more fractional seconds than are specified in your metadata, or is not constructed using the format specified in your metadata.

I believe that the IsValidDate() only accepts the system default date format, if the string is different then IsValid('date',In.DateColumn,'%yyyy-%mm-%dd') would work, assuming your date format is 9999-12-31.

Or that.

I'm sorry,
I cannot see "premium content".

thank you anyway.

We know. But there's plenty of information you can see, didn't any of it help? Let us know if you still have any specific questions... and I'm still wondering why your subject says "Invalid Time" and then you asked how to validate a date. Are you actually wondering how to validate a timestamp?

Yes, but I find only "isValid()" function.

There're not other functions like IsValidDate or IsValidTimestamp.

I need to check if a string is a timestamp

thank you

What version are you on? Regardless - did you check the documentation for IsValid? It is multi-purpose as you might gather from the name:

The IsValid() documentation wrote:Returns whether the given string is valid for the given type. Valid types are "date", "decimal", "dfloat", "sfloat", "int8", "uint8", "int16", "uint16", "int32", "uint32", "int64", "uint64", "raw", "string", "time", "timestamp", "ustring".

There's more in the docs. Give that a shot.

My DS version is 8.1

I don't know the syntax of IsValid() to check a timestamp

I've, in a file...

NAME;YYYYMMDDHH24MISS;LOCATION

I need to check if timestamp field is a valid timestamp

tks

The syntax is in the documentation. Does your version support an 'optional format string'? That would simplify things but from some searches here and online 8.1 might not allow that optional third parameter.