Date search

paolcon · Post by **paolcon** » Mon May 09, 2016 3:32 pm

Hi everybody, can you help me? Your product is realy the top, but i'm not.

I have a Datatime field "Service Date",
un search parameters i set

FieldSearch 1 >= (ServiceDate)

FieldSearch 2 <= (ServiceDate)

Can i set in default metodh FieldSearch2= (ServiceDate)+7 days ? example: FieldSearch 1 2016/05/09 and FieldSearch 2 in automatic 2016/05/16

Thanks

motfs · Post by **motfs** » Tue May 10, 2016 12:38 pm

You can use the Recordset_SearchValidated server event to check if there is <Field>.AdvancedSearch.SeachValue2. If there is no value, you can get the SearchValue and convert it to DateTime and use DateTime.AddDays() to add the number of days. and convert it back to string (ToString(<format>)) and set the SearchValue2. See Server Events and Client Scripts -> Recordset_SearchValidated (Example) in help file for more details.