Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I am having problems to understand the first_month_of_year parameter of the InMonths function.
In the examples seems that if you don´t specify that parameter the timestamp is always a previous date than the base_date parameter.
I don´t know why "InMonths( 4, '25/05/2006', '01/03/2006', 0, 3)" makes the search period 01/03/2006 to 30/07/2006 and, in the other cases, the search period is always going from the base_date backwards.
Thanks in advance.
1th param 'n_months' is set to 4, meaning you want to divide you year into 4 month periods. There is three 4 months periods in a year.
Your last param 'first_month_of_year' is set to 3, meaning your first month of an year is March.
Your base date is within the first 4 month period of your year, that is March, April, May and June. Any date within that interval will become included in that setup. Are you sure you get July dates included in your setup?
1th param 'n_months' is set to 4, meaning you want to divide you year into 4 month periods. There is three 4 months periods in a year.
Your last param 'first_month_of_year' is set to 3, meaning your first month of an year is March.
Your base date is within the first 4 month period of your year, that is March, April, May and June. Any date within that interval will become included in that setup. Are you sure you get July dates included in your setup?