Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community !, I do not know how to solve this problem ...
I have a table with 2 fields, 1º column is the Name of the branch and the other indicates if they met OBJETIVE, this I have a month close, so I want add a third column but cover the entire month, for example 12/2017 (December 2017). How can I do to solve it?
To clarify I have other records with the field DATE and that is configured in the script with the CALENDAR function.
NAME BRANCH | OBJETIVE | MONTH YEAR | or | MONTH |
Córdoba | Yes | 12/2017 | 12 | |
Catamarca | No | 12/2017 | 12 | |
La Rioja | No | 12/2017 | 12 | |
Santa Fe | Yes | 12/2017 | 12 |
I appreciate much your time and attention.
Hi,
try to add Date field instead of monthYear or Month (because these all can extracted form Date).
Fact:
NAME BRANCH,OBJETIVE,DATE
Calendar: using the master calendar script you can do periodically report (like yearly,weekly, monthly etc)
Year, Month, Week, DATE
ref: master calendar script
Hi Devarasu R, thanks for your answer,
What happens is that I already tried to add the Date field, but I have to place for example 01/11/2017 (DD, MM, YYY), then the values that I completed in the same row of the excel file (for example) only go to show on 01/11/2017 and not during the days 02/11/2017, 03/11/2017, ETC.
You will have to generate the dates in between the beginning and the ending of the month, assuming I'm reading your question correctly.
Tienes que generar los dias entre la comienza y el fin del mes. Deberias a usar un calendario maestro.
Dastin, If I do not understand wrong, tells me that I have to do something like this:
NAME BRANCH | OBJETIVE | DATE START | DATE END |
Córdoba | Yes | 01/12/2017 | 31/12/2017 |
How do I relate it to the master calendar?