Date Validation

Post Reply
Posts: 16
Joined: Wed Jun 28, 2017 12:27 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2013

Date Validation

Post by vishalpoddar90 » Fri Dec 22, 2017 10:57 am

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.


User avatar
jim wood
Site Admin
Posts: 3617
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA

Re: Date Validation

Post by jim wood » Fri Dec 22, 2017 1:08 pm

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

Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply