TM1 Forum

Guys,

I'm currently working with 10.1.1. I've created a web sheet where users will update project stage dates. Within Excel when a date is missing it shows as blank but when published in TM1 Web it displays a date that corresponds to the date value of 0. To give you more background we store the date values as numeric values and then format the cube display. In Excel I have set the format to dd/mm/yyyy. I've done some digging and it sounds like I can't do anything about it. Could somebody confirm if this is the case?

Excel view: Web view: Thanks,

Jim.

You just need to use the excel formatting to indicate what to do for zero value so "dd-mm-yy;;" will display as blank for minus and zero.

Problem is when you enter a date from blank; the web format can be annoying and require it in a very specific format dependent on region (more specific than changing from one date to another) but user training should get you there.

Thanks for getting back to me so quickly Declan. I tried to move to custom and went for dd/mm/yyyy;; and this what I got:
Do you think something like mm/dd/yyyy;-; will work?

Jim.

Nailed it using the following format: mm/dd/yyyy;;""

Jim.

That's interesting; it's something I have used a lot - we have 1 customer still using it in a lot of web forms for cognos express 10.1.
Maybe it needs to be the same format as your regional settings?
I think to be fair what I specifically tend to use is dashes instead of blanks, so without logging in I believe we use "dd-mm-yyyy;;-" and that will be in a server that has UK date formatting.

declanr wrote:That's interesting; it's something I have used a lot - we have 1 customer still using it in a lot of web forms for cognos express 10.1.
Maybe it needs to be the same format as your regional settings?

Quite possibly. Also we're not on the latest version of Excel either. That may have something to do with it?

Excel should be fine; this is something I first started implementing a while ago... think the express customer is still using excel 2007 or 2010 due to the whole awful process of installing CX back then meaning it had a hissy fit if it didn't detect what it deemed to be the correct version of excel despite it working perfectly with newer versions if you hacked it in.