When validateDate has date like year = 1930, month = 06,day = 31then"Validate Date Fields" mapper returns true, why? Shouldn't it return false ? tib:validateDate("yyyy-mm-dd","1930-06-31")
Article ID: KB0086689
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
-> Date Format and Date Validation in BW.
1) So, in above example you can see that date format is give as : "yyyy-mm-dd"
2) Then BW will validate date for the format/pattern and not for the validity of Date
(What I mean here is date according to Gregorian Calendar.
e.g. 2005-02-31 is valid date for BW since it satisfies the format but it not a date in calendar.)
3) If you want BW to validate your date , whether if it is a in reality a Valid date or not ( Gregorian Calendar wise ) - then Date format should be yyyy-MM-dd instead of yyyy-mm-dd
Issue/Introduction
When validateDate has date like year = 1930, month = 06,day = 31then"Validate Date Fields" mapper returns true, why? Shouldn't it return false ?
tib:validateDate("yyyy-mm-dd","1930-06-31")
Feedback
Yes
No
Powered by
