have you tried to use to_date() instead of cast?
# suitescript
w
have you tried to use to_date() instead of cast?