To Restrict an user to enter date value for a date field

Post Reply
manoj928
Posts: 60
Joined: Thu Mar 17, 2011 2:13 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.1
Excel Version: 2010

To Restrict an user to enter date value for a date field

Post by manoj928 »

Hello All,

How i can restrict an user to enter date only value in a date field with format MM/DD/YYYY. I tried it using Custom Style, i set the format as MM/DD/YYYY, but i can see, field is still accepting a string value instead.

Your help will be really appreciated.

Thanks,
Manoj
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: To Restrict an user to enter date value for a date field

Post by Alan Kirk »

manoj928 wrote: How i can restrict an user to enter date only value in a date field with format MM/DD/YYYY. I tried it using Custom Style, i set the format as MM/DD/YYYY, but i can see, field is still accepting a string value instead.
And where exactly is this "date field"? In a cube, in a worksheet, in something else? Because TM1 does not have date fields, as explained here.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
manoj928
Posts: 60
Joined: Thu Mar 17, 2011 2:13 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.1
Excel Version: 2010

Re: To Restrict an user to enter date value for a date field

Post by manoj928 »

Thanks for reply,

Actually users will enter data in cube through web-sheets and in any data field, we want them to enter value in format MM/DD/YYYY. So what is best way to achieve it?
Post Reply