mysql query between 2 date

[allin81]

SELECT *
FROM offerte
WHERE (cast(:datadal as date)  BETWEEN valida_da  AND valida_fino)
and (cast(:dataal as date)  BETWEEN valida_da  AND valida_fino)

forse sto sbagliando ma modifico cosi':

SELECT *
FROM offerte
WHERE cast(:2022-05-01 as date)  BETWEEN valida_da  AND valida_fino
and cast(:2022-05-06 as date)  BETWEEN valida_da  AND valida_fino

pero' mi restituisce errore:
#1064 - Errore di sintassi nella query SQL vicino a ':2022-05-01 as date) BETWEEN valida_da AND valida_fino
and cast(:2022-05-06 a' linea 3