Calendar object date restriction

[raju_salmon]

Hi,

In one of my application i have created two calendar objects two select date range for user. These steps i have followed.

Create 4 variables: Date is the field in my app

vLimit1 - =Min(Num(Date))

vLimit2 = =Max(Num(Date))

vToDate = Null()  - Changes based on user selection

vFromDate = Null()  - Changes based on user selection

Created two calendar objects using vToDate and vFromDate variables with min and max values are vLimit1 and vLimit2.

Applied variable level triggers on vToDate and vFromDate with below expression on Date field (select in field)

='>='&Date(vToDate)&'<='&Date(vFromDate)

Now this is working absolutely fine, if i select date range from calendar objects then Date field getting selected. But however i cannot able to select out of the range (which i have already selected ) unless i clear the date field. This is may because of Min and Max date for vLimit1 and vLimit2 variables.

My problem is, can we select any date range without clearing the date filter? Please suggest.

Thanks a ton,

Raju.

[jonathandienst · Accepted solution]

Do you mean you want the limits to remain the same even after you've selected a date? Then

     Set vLimit1 = =Min({1} Date);

     Set vLimit2 = =Max({1} Date);

Num() is probably unnecessary here - it is a formatting function.

[arvind_patil]

Hi Raju,

Please give sample Example of It. then it will understand more .

Thanks,

Arvind Patil