Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
raju_salmon
Creator II
Creator II

Calender Object Issue

I have created calendar object with the below process however i cannot able to select the dates in DATE field.

Created below variable:

vLowerLimit = Num(Min(DATE))

vUpperLimit = Num(Today())

vStartDate = ''

vEndDate = ''

Created Calender Object with variables vStartDate and vEndDate

MIN VALUE =vLowerLimit

MAXVALUE  =vUpperLimit

Added triggers at document level for variables vStartDate and vEndDate for

Selectinfiled -  Field (DATE)           Search String ( ='>='&vStartDate&'<='&vEndDate)

Please find the sample attachment for reference. I cannot able to select particulate dates in Date field.

1 Solution

Accepted Solutions
Kushal_Chawda

You can create the button & Set the variable values to null on click.

See the attached

View solution in original post

5 Replies
tresesco
MVP
MVP

Add date() in your search string like:

='>='&Date(vStartDate)&'<='&Date(vEndDate)

raju_salmon
Creator II
Creator II
Author

Thanks tresesco.

This is working, i need one more step to do.

When i select date on calendar object, the y are not unselected when i click clearall button. Do i need to add any action for clear all button?

Kushal_Chawda

Remove Variable event trigger & Create the button (here you can provide the trigger to select the DATE) to apply filter when dates from calender object gets selected i.e on clicking button Date range will be selected in DATE field



raju_salmon
Creator II
Creator II
Author

Hi,

Thanks for response.

Since i need to create calendar object, i have made it based on tresesco response.

However i need to clear the calendar date selections when i click on clear all button. Can i do that with any way?

I mean i need to clear the value in StartDate and EndDate variable by clicking button.

Kushal_Chawda

You can create the button & Set the variable values to null on click.

See the attached