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
To Restrict an user to enter date value for a date field
-
- 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
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.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.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
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?
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?