Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Floor(MonthStart(Date)
Can you elaborate? Within script? in a chart?
or
Day(Monthstart(Date))
Hi,
Try creating Master calendar and then it would be easy to visualize on time/Date period.
Regards,
Pankaj
Check this out.
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
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