Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created two calendar objects 'From'(Min=min(InvoiceDate,Max=EndDate), 'To'(min=StartDate,Max=Max(InvoiceDate))
Created two trigger action for InvoiceDate( ='>='& StartDate& '<='& EndDate )
When I want to choose another date or reselect sometimes I'm unable to do it, especially with To-field. (after clear all I can) But:
If my first selection is for From-field I can't(never) do selection for To-field. So what's wrong? How to fix it? If you have any examples, please send it.
Sometimes, The functionality is not work as we hit. This is the case, can you let us know which object you took to selection. May be Calendar object helps you. In fact, You should call up them(Variables).
FYI, Look here Selecting Arbitrary Date Ranges - YouTube
I saw this video and can say that everything is same except for objects: I took calendar objects, not just input boxes.
Changed Min and Max dates for =min({1}InvoiceDate) and =max({1}InvoiceDate) and now it's ok, but what does {1} mean? Without {1} situation doesn't improve.
And now I can choose invalid date ranges, but I'll fix it later.