Mike,
I had exactly the same problem.
It occurs because XLSReadWrite adds an '=' in front of the Date values.
This is how I fixed it:
xlsValidation.Formula1 := 'DATEVALUE("01/01/1900")';
xlsValidation.Formula2 := 'DATEVALUE("31/12/2099")';
Kind Regards,
Geert
Search found 1 match
- Tue May 16, 2023 8:38 am
- Forum: XLSReadWritwII 6
- Topic: Data Range Validation
- Replies: 1
- Views: 1662