I have an active form in which date is entered in yyyymmdd format.
I tried Custom validation but its not working.
How can I validate the data entered in the cell.
Thanks
Date Validation
-
- Posts: 19
- Joined: Wed Jun 28, 2017 12:27 pm
- OLAP Product: IBM Planning Analytics
- Version: 2.0.76
- Excel Version: 365
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Date Validation
Make sure the date fields are numeric. The format them as dates. That way it shouldn't take anything else,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7