Last day of the month

[Anonymous]

Hi Guys,

I have a function question; See below table. I need only the value of the first date of the month. What's the correct date function for this...

Kind regards,

Robert

Date	NEW	OPEN
31/12/2015	32	32
03/01/2016	0	32
10/01/2016	0	32
17/01/2016	0	32
24/01/2016	0	32
31/01/2016	0	32
07/02/2016	0	32
14/02/2016	0	32
21/02/2016	0	32
28/02/2016	0	32
29/02/2016	0	32
06/03/2016	0	32
13/03/2016	0	32
20/03/2016	0	32
27/03/2016	0	32
31/03/2016	0	32
03/04/2016	0	32
10/04/2016	0	32
17/04/2016	0	32
24/04/2016	0	32
30/04/2016	0	32
01/05/2016	0	32
08/05/2016	0	32
15/05/2016	0	32
22/05/2016	0	32
29/05/2016	0	32
31/05/2016	0	32
05/06/2016	0	32
12/06/2016	0	32
19/06/2016	0	32
26/06/2016	0	32
30/06/2016	0	32
03/07/2016	0	32
10/07/2016	0	32
17/07/2016	0	32
24/07/2016	0	32
31/07/2016	0	32
07/08/2016	0	32
14/08/2016	0	32
21/08/2016	0	32
28/08/2016	0	32
31/08/2016	0	32
04/09/2016	0	32
11/09/2016	0	32
18/09/2016	0	32
25/09/2016	0	32
30/09/2016	0	32
02/10/2016	0	32
09/10/2016	0	32
16/10/2016	0	32
23/10/2016	0	32
30/10/2016	0	32
31/10/2016	0	32
06/11/2016	0	32
13/11/2016	0	32
20/11/2016	0	32
27/11/2016	0	32
30/11/2016	0	32
04/12/2016	0	32
11/12/2016	0	32
18/12/2016	0	32
25/12/2016	0	32
31/12/2016	0	32
01/01/2017	-2	30
08/01/2017	0	30
15/01/2017	0	30
22/01/2017	0	30
29/01/2017	0	30
31/01/2017	0	30
05/02/2017	0	30
12/02/2017	0	30
19/02/2017	0	30
26/02/2017	0	30
28/02/2017	0	30
05/03/2017	0	30
12/03/2017	0	30
19/03/2017	0	30
26/03/2017	0	30
31/03/2017	0	30
02/04/2017	-1	29
09/04/2017	0	29
16/04/2017	0	29
23/04/2017	0	29
30/04/2017	0	29
07/05/2017	0	29
14/05/2017	0	29
21/05/2017	0	29
28/05/2017	0	29
31/05/2017	0	29
04/06/2017	0	29
11/06/2017	0	29
18/06/2017	0	29
25/06/2017	0	29
30/06/2017	0	29
02/07/2017	0	29
09/07/2017	0	29
16/07/2017	0	29
23/07/2017	0	29
30/07/2017	0	29
31/07/2017	0	29
06/08/2017	0	29
13/08/2017	0	29
20/08/2017	0	29
27/08/2017	0	29
31/08/2017	0	29
03/09/2017	0	29
10/09/2017	0	29
17/09/2017	0	29
24/09/2017	0	29
30/09/2017	0	29
01/10/2017	0	29
08/10/2017	0	29
15/10/2017	0	29
22/10/2017	0	29
29/10/2017	0	29
31/10/2017	0	29
05/11/2017	0	29
12/11/2017	0	29
19/11/2017	0	29
26/11/2017	0	29
30/11/2017	0	29
03/12/2017	0	29
10/12/2017	0	29
17/12/2017	0	29
24/12/2017	0	29
31/12/2017	0	29

[Anonymous]

Floor(MonthStart(Date)

[sunny_talwar]

Can you elaborate? Within script? in a chart?

[Anonymous]

or

Day(Monthstart(Date))

[passionate]

Hi,

Try creating Master calendar and then it would be easy to visualize on time/Date period.

Regards,

Pankaj

[neelamsaroha157]

Check this out.

[Anonymous]

Hi,

I would like to try both, in the script and in the chart.

But the values are summed up when reporting on month bases. I just need the value of the first day of month.

Kind regards,

Robert

[victorgil88]

Hi Robert,

I think this should work:

          Day(MonthStart(Date))

if the field Date is not recognize as a date then:

          Day(MonthStart(date(Date,'DD/MM/YYYY')))

Best regards