No options to pass userEnteredValue date for ['DATE_BEFORE', 'DATE_AFTER', 'DATE_ON_OR_BEFORE', 'DATE_ON_OR_AFTER'] conditions, force insert relative date only

[ayushmantiwari]

pygsheets/pygsheets/worksheet.py

Line 1739 in 033334e

json_values.append({'relativeDate': str(value)})

Error trace -

{
"message": "Error while generating gsheet template: <HttpError 400 when requesting
https://sheets.googleapis.com/v4/spreadsheets/16f0-iNIPPO3UgtBnSUWfTCc6uzatnJ4vyW8hCznJucI:batchUpdate?fields=%2A&alt=json
returned "Invalid value at 'requests[0].set_data_validation.rule.condition.values[0].relative_date' (type.googleapis.com/google.apps.sheets.v4.BooleanCondition.RelativeDate), "{'relativeDate': None, 'userEnteredValue': '10/10/2024'}"". Details: "[{'@type': 'type.googleapis.com/google.rpc.BadRequest', 'fieldViolations': [{'field': 'requests[0].set_data_validation.rule.condition.values[0].relative_date', 'description': 'Invalid value at \'requests[0].set_data_validation.rule.condition.values[0].relative_date\' (type.googleapis.com/google.apps.sheets.v4.BooleanCondition.RelativeDate), "{\'relativeDate\': None, \'userEnteredValue\': \'10/10/2024\'}"'}]}]">"
}