TM1 Forum

Hi ,

I am having an excel where dates are filled and passed to a TI using the action button .

Data validation is done on excel and requires a date to be entered.

So I enter 04/14/2017 and then I hit action button , but the value thats read in ti is

4/14/2017 12:00:00 AM comes with time , is there a way for me to get only the date 04/14/2017

Should I manually get it trimmed to date only . Does changing any setting in excel cell allows to pass the date only .

Thanks,

Have you tried anything yet? Try changing the formatting of the cell in Excel and see what it does. Don't always run to someone else for help. Be inquisitive and try things. It's the only way you are going to learn,

I did change the format as text and it would work ,but then the data validation on excel sheet would not work . So then i have to do a validation on to see if its a date in excel from a text column .

manu0521 wrote: ↑Wed Sep 18, 2019 7:02 pm I did change the format as text and it would work ,but then the data validation on excel sheet would not work . So then i have to do a validation on to see if its a date in excel from a text column .

You realize, of course, that a date in Excel is a number so when passing it to a TI process it is going to be a number that you are passing. Think outside the box. What are you doing in the TI with the date? Does it represent an element? Add an attribute to the date dimension that has the numeric date as an alias (keeping in mind you'll have to store the alias as a string and do some number to string conversion in the TI).