Hi, my app have three buttons that change 2 variables (FILTER_DATA_INICIO and FILTER_DATA_FIM) that I use as a date filter and it have 3 options: current week(SEMANA ATUAL), next week(PROXIMA SEMANA) and current month(MÊS ATUAL).
Each button changes the variables to de desired exibition with the following formulas:
SEMANA ATUAL
FILTER_DATA_INICIO
ADD_DURATION(NOW(), -(pageVars.DIA_SEMANA-1),"days")
FILTER_DATA_FIM
ADD_DURATION(pageVars.FILTER_DATA_INICIO, 1, "weeks")
PROXIMA SEMANA
FILTER_DATA_INICIO
ADD_DURATION(NOW(), (-(pageVars.DIA_SEMANA-1)+7),"days")
FILTER_DATA_FIM
ADD_DURATION(pageVars.FILTER_DATA_INICIO, 1, "weeks")
MÊS ATUAL
FILTER_DATA_INICIO
SET_DATETIME_COMPONENT(NOW(), 1, "date")
FILTER_DATA_FIM
ADD_DURATION(ADD_DURATION(pageVars.FILTER_DATA_INICIO, 1,"months"), -1,"days")
pageVars.DIA_SEMANA gets FORMAT_DATETIME_LOCAL(NOW(), “E”) and is used to find the first day of a week
The error happens when the user selects “PROXIMA SEMANA” and then select “SEMANA ATUAL”, it show no logs or error messages, just an apollogize from SAP
APP ID :409049
Page 3 (02 HOME)