How to extract Valid Date format records

[DSguru2B]

It is expecting format in lower case. %yyyy-%mm-%dd

[somu_june]

Hi DSguru,

Iam geting the same error and records are going to other/log condition and the error Iam getting after using %yyy-%mm-%dd format is

Error

APT_CombinedOperatorController,0: The schema type "date" does not take parameters "%yyy-%mm-%dd"


Thanks,
somaraju

[us1aslam1us]

Have you tried it without specifying the format. Let it pick the default format which is %yyyy-%mm-%dd.

Code: Select all

IsValid("date", DSLink2.Date1)

If this doesn't work specify the format on Source column like date1[%yyyy-%mm-%dd] . I had done that once but i don't remember which one works exactly.

[somu_june]

Hi us1alslam1us,

Thanks for solving my problem.








Thanks,
Somaraju.