How to extract Valid Date format records
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Have you tried it without specifying the format. Let it pick the default format which is %yyyy-%mm-%dd.
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.
Code: Select all
IsValid("date", DSLink2.Date1)
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Thomas Alva Edison(1847-1931)