My date is in YYYYMMDD format and when I use the function IsValid
for dates like 20100100 , an invalid date, the function says it is valid. Please advise.
DataStage Date Validation
Moderators: chulett, rschirm, roy
-
datastagenewbie
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Probably a bug. Day 00 is invalid. Involve your support provider.
(I presume you used "%yyyy%mm%dd" as the format string. "20100100" is valid for "%dd%mm%yyyy". The year is 100.)
(I presume you used "%yyyy%mm%dd" as the format string. "20100100" is valid for "%dd%mm%yyyy". The year is 100.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.