How to show dates format

[Anonymous]

Hi All,

Below is my format

Jan - 17

Jan - 17

Jan - 17

Jan - 17

Jan - 17

Jan - 17

Jan - 17

Jan - 17

Jan - 17

Jan - 17

Jan - 17

Feb - 17

Feb - 17

Feb - 17

Feb - 17

Feb - 17

Mar - 17

Mar - 17

Mar - 17

Mar - 17

Apr - 17

Apr - 17

Apr - 17

May - 17

out put be like

Jan -17

Feb -17

Mar -17

Apr -17

May -17

Regards,

[prieper]

LOAD DISTINCT ??

[tresB]

Where are you getting the data from? Excel?

[Anonymous]

Nope!!

Actuval data is like this:

1/10/2017

1/11/2017

1/12/2017

1/12/2017

1/17/2017

1/17/2017

1/17/2017

1/17/2017

1/18/2017

1/25/2017

1/27/2017

2/6/2017

2/8/2017

2/8/2017

2/14/2017

2/28/2017

3/8/2017

3/22/2017

3/22/2017

3/23/2017

4/7/2017

4/10/2017

4/25/2017

5/1/2017

[tresB]

You are probably using date() to format it to see the MMM-YYYY format. Instead try using monthname(), like:

MonthName(Date) as Month

[tresB]

And if you need that '-' too, try like:

Date(MonthStart(Date), 'MMM-YYYY') as Month

[el_aprendiz111]

hI,

LOAD Distinct Date;
LOAD * Inline
[
Date
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Jan - 17
Feb - 17
Feb - 17
Feb - 17
Feb - 17
Feb - 17
Mar - 17
Mar - 17
Mar - 17
Mar - 17
Apr - 17
Apr - 17
Apr - 17
May - 17
];