Hi, I want to have a date input parameter (because of the date picker) but the date should be formatted to YYYYMMDD as it is stored in the database as a number. How can I achieve that?
Sample Query:
Select date_as_number_column from table_foo where sample_data = ‘{{date}}’
Now for example if I choose in the date picker today (2020-10-13) the query parameter sent to the database should be 20201013.
Thanks a lot for your time and help.
With best regards,
Joshy