Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I'm more than 1 hour researching a timetable to do the following:
I have two on my dashboard calendar object, where one is to select the start date and end date to another.
to make two objects using search, where at first I was selecting a particular date field or higher and another that would select the same date in another table with only smaller or equal.
Is to do with the calendar object or something that looks like the calendar (I saw some very good examples of John Witherspoon)?
Hi,
not yet have a solution, if someone can help me.
if you use something like this in de expression:
if(CalendarioDataEnvioAux.Data >= v_dataIni and CalendarioDataEnvioAux.Data <= v_dataFim, DATA_TO_SHOW)
Don't know for sure how you use the date selection . . . but if you want a date to be between to other dates this is the way you get a null value for all fields which are not compliant to the if expression. Those rows shall not be displayed in the chart table ...
rgrds,
Anita
Hi,
I am not sure whether I understood your requirement correctly.
What I understand is that you want show the transactions falling between two dates. If this is the case then I think the attached one after some changes is good enough else please let me know.
Best Regards,
Sajeevan
It's nothing more than the if statement in the expression, when null the row is not shown ...
The sample of Sajeevan is exactly like I suggested . . . if this is not working . . . be more specific what date fields you mean . . .
rgrds,
Anita
Sajeevan,
thank you, little was missing and you solved.
Please dont forget to mark the thread as solved if you have found what you where looking for, or tag helpful comments.
Hi,
Most welcome. Please mark it as answered so that others do not spend their time.
Best Regards,
Sajeevan
Great that your problem is solved ... and as the others mentioned . . . tag all helpfull comments 😉