Error with Object Format

building semantic layer
1

Hello, All.

I am currently designing a new universe and one object was defined:
Name: Menesis
Type: Number
Select: month(d_datums.date_date).
The Object works fine. We can see 01 for January, 02 for February, etc.

But Problem occurs when the Object Format -> Date/Time -> ‘Mmm’ was applied. Every month number was replaced with a word January.

Any ideas?

Aleksejs Jevsejenko
A/S DATI, www.dati.lv

Listserv Archives (BOB member since 2002-06-25)

2

Aleksejs,
I was having the same problem in BO 4.1.3, but the problem seems to be solved in BO5.
If you’re having the problem in BO5, you still have the alerters to display your exact month with ‘Mmm’ format

Hamid

Listserv Archives (BOB member since 2002-06-25)

3

Aleksejs,

It is not a problem with formatting, b’cos you cannot format a number with a Date Format model. The format ‘Mmm’ works only on date fields and not on numeric fields.

I would suggest you to create another object called month with the type as date and select as ‘d_datums.date_date’ and Format as ‘Mmm’.

–
Prasad Shenoy
CMOS Soft Inc., CA

Hello, All.

I am currently designing a new universe and one object was defined:
Name: Menesis
Type: Number
Select: month(d_datums.date_date).
The Object works fine. We can see 01 for January, 02 for February, etc.

But Problem occurs when the Object Format → Date/Time → ‘Mmm’ was applied. Every month number was replaced with a word January.

Any ideas?

Aleksejs Jevsejenko
A/S DATI, www.dati.lv

Free Internet Access from AltaVista: Get it, share it & win! Yahoo Search - Web Search

Listserv Archives (BOB member since 2002-06-25)