Date Validation

Post Reply
vishalpoddar90
Posts: 19
Joined: Wed Jun 28, 2017 12:27 pm
OLAP Product: IBM Planning Analytics
Version: 2.0.76
Excel Version: 365

Date Validation

Post by vishalpoddar90 »

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
User avatar
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

Post by jim wood »

Make sure the date fields are numeric. The format them as dates. That way it shouldn't take anything else,

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
Post Reply