TM1 Forum

Hi experts,

I read 'almost' all the subjects related to date, and I have not found my answer yet-
I have a date measure - I know TM1 recognize it as a date because it comes from a Dayno and Date formula.

How would I ask TM1 to DISPLAY this date in the format that I entered in the attributes (like d-mmm-yy)?

Thanks
PS: I had another issue which is data entry of a date in Xcelerator- And I found a workaround which is : ask the users to enter a ' before entering the date (makes it a text field)- Yes, it resolves the problem- But do we have another way?

So ...

TM1 does not recognise that it is a date just because you use particular functions in its formula. It is a number or it is a string.

I presume when you talk of a date measure that it is identified by a particular item on the last dimension of a cube. If it is a number then you can set the Format attribute of that item to one of the date formats.

However ... The format attribute is expecting a number based on 1970-01-01 (like Excel) but DAYNO gives you a number based on 1960-01-01 and so you will need to do some adjustment.

If you have read 'almost' all of the subjects then I hope you have read Alan's very comprehensive guide here http://www.tm1forum.com/viewtopic.php?f=21&t=2441. If not then you must.

Thank you Duncan,

My problem was much more simpler than I thougt- Yes, I had read Alan's subject- But YOU answered my question I think without knowing.
I did not know that the measure had to be numeric in order for the date format of the attribute to work. THat was that simple!!

Thank you-