IsValid function usage
Posted: Mon Oct 15, 2007 12:03 pm
Im trying to use IsValid function.
The dev guide says the arguments for usage is
type(string) format (string).
My input column type is - string and output column type is - string
But before I moved the data over to another stage I want to check if the input column type
could be converted to a date of format (yyyy-mm-dd) .
I tried the usage of this function but I have failed.
How do I check if the input type could be converted to a date of format yyyy-mm-dd? with the function IsValid?
Thanks
The dev guide says the arguments for usage is
type(string) format (string).
My input column type is - string and output column type is - string
But before I moved the data over to another stage I want to check if the input column type
could be converted to a date of format (yyyy-mm-dd) .
I tried the usage of this function but I have failed.
How do I check if the input type could be converted to a date of format yyyy-mm-dd? with the function IsValid?
Thanks