I have a field 'Date' in unix format (dd-mmm-yyyy)
I want to do a range search on this field for:
Lower range: Date equals the date entered by viewer
Upper range: + number of days as entered by viewer
This is to allow viewers to search for events between the 'start date' and the 'start date + the number of days'.
Is this possible?
I've tried the -gt -lt searches on the Date field with the lower range being one day earlier than the Date entered using the mods discussed on the forum but got a misconfiguration error.
Thanks
Alba
I want to do a range search on this field for:
Lower range: Date equals the date entered by viewer
Upper range: + number of days as entered by viewer
This is to allow viewers to search for events between the 'start date' and the 'start date + the number of days'.
Is this possible?
I've tried the -gt -lt searches on the Date field with the lower range being one day earlier than the Date entered using the mods discussed on the forum but got a misconfiguration error.
Thanks
Alba