Format Dimension - Script

[#1]

Morning

How to format a date from 12.15.2015 to monthyear 12.2015 and a number 12,44567778 to  decimal number 12,45 while loading for using later as dimension?

LOAD

monthyear

decimalnumber

Or how to format dimension?

Is it possible - I searched for solutions but didnt found.

Thank you.

[jonathandienst]

LOAD

     Date(Date#(monthyear, 'MM.DD.YYYY'), 'MM.YYYY') As Date,

     Num(decimalnumber, '0,00', ',') As Number,

     ...

[maxgro]

Date(MonthStart(date#('12.15.2015', 'MM.DD.YYYY')), 'MM.YYYY')

or without MonthStart

round(number, 0.01)

[sunny_talwar]

For date you can use date function and for number use Num() function

Date(DateField, 'MM.YYYY') as DateField,

Num(NumberField, '##.00') as NumberField

[#5]

Thank you - I am happy now.