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
IsValid function usage
Moderators: chulett, rschirm, roy
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")
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.