Get only Month

[bharatkishore]

Hi All,

I have a date field with date and time and based on the following expression i removed the time stamp:

     (Date(Floor(TecoProxy), 'MM/DD/YYYY')) as Date

Now i need to get only one day and 12 months and the years like

1/1/2015

2/1/2015

3/1/2015

.and so on.

Can you please tell me how can i do it.

Thanks,

Bharat

[kristof_j]

change your date format into 'D/M/YYYY'

The number of Ds, Ms and Ys defines the length of what you'll see.

D	1
DD	01
M	1
MM	01
MMM	jan
MMMM	january
YY	18
YYYY	2018

[petter · Accepted solution]

Date(MonthStart(Floor(TecoProxy)), 'M/D/YYYY')

If you need to sum up the individual dates for a month you would need to use a GROUP BY clause at the end of your LOAD statement and do a Sum() or other aggregation function on the measures/metrics fields.

[bharatkishore]

Thanks a lot