Date format conversion

[Former Member]

Hi,

The output of the fiscal year/period from the universe designer is in the format 01.2009 but I need it in 200901 this format.

So how can I achieve this in the universe designer? i.e. the output format of my fiscal year/period should be in yyyymm format & no period in between?

Can you pls guide me step by step?

thanks in advance,

shresh.

[former_member207342]

which database are you running on.

--Kuldeep

[former_member207342]

for oracle it should be like

to_char( to_date('01.'||'01.2009','dd.mm.yyyy'),'yyyymm')

Basically I am prefixing 01 as dummy day to the current date and then converting it to date format.

so your object definition would be like

to_char( to_date('01.'||<YOURDATECOLUMN>,'dd.mm.yyyy'),'yyyymm')

Let me know if it works for you as expected.

--Kuldeep