Universe creation

[Former Member]

HI All,

i am trying to create a universe.  i have date field.  I am trying to create a dimension on date field.  What i want was month(datefield) but i want result as mm like 01 02. 

and i am trying to join month and year 012013 022013 how can i do that.  on the dimension itself.

i tired month(datefield)+''+year(datefield) then it is adding them both for example i have 07 2013 then i am get 2020 rather giving me 072013

can someone help me out please.  This is very urgent thank for all who always helps.

[former_member207878]

Use below to get result as 13/07/2012 to 072012:

=FormatDate(<datefield>;”MMyyyy”)

Also check below link for more information regarding conversion of dates:

[Former Member]

Hi Sahil,

Thank you for your reply.  But i am actually looking in information design tool while creating dimensions.  because in information design tool there is no FormatDate function.