Changing date to Month Year??

[#1]

How do I change a date from MM/DD/YYYY and MMM-YY to MMM YYYY?

How would I then restrict the chart to show only the most recent month in the dimensions?

TIA

[vishsaggi]

In your script try like:

Date(Date#(YourdateField, 'MM/DD/YYYY'), 'MMM YYYY') AS DateFieldName

OR

Date(Date#(YourdateField, 'MMM-YY'), 'MMM YYYY') AS DateFieldName

Dim:

//Reference taken from here check here?

Calculated dimension for max date of each month

= Aggr(Max(DateFieldName), DateFieldName)

[#3]

This did not work, but I figured it out based on this.

How do I show only the previous months data in the dimensions of a bar chart?

[#4]

for the dimension, that is showing for multiple months. I am trying to only show one month of data- being the last month

[vishsaggi]

Can you share your sample app for a quick look at it?