DSXchange

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.

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.)