Page 1 of 1

IsValid function usage

Posted: Mon Oct 15, 2007 12:03 pm
by ds_is_fun
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

Posted: Mon Oct 15, 2007 12:19 pm
by DSguru2B
I dont think IsValid() works like that. For example, if you are checking for a date coming from string, you will have to do something like

Code: Select all

IsValid(StringToDate(in.Date, "%yyyy-%mm-%dd"), "Date")