How to create a date similar to this

[#1]

oct-2013 to 10/2013

[satheshreddy]

Hi Allen,

if you have same fields also you cont do,

first you have to check weather the all variables are created are any changing happen because you have used so many variables you had in EXP.

if you have all variables and columns are fine you can able to use the exp.

Regards

Sathish

[#3]

Can you please explain how what the numbers mean? and if there are any alternative ways to do this?

[antoniotiman]

Hi,

Date(Date#('Oct-2013','MMM-YYYY'),'MM/YYYY')  ->  10/2013

Regards,

Antonio

[eva_filep]

1. Assuming that the field containing oct-2013 is a date field not a string just create a new master dimension:

Date([Field Name],'MM/YYYY')

and use that in your visualization.

2. Format the field from the load script, same way.