hi i'm trying to convert a date/time field into a date field so that I can compare it another date field and also use it to set a date field plz help with the SQL

CAST({datetimefield} AS DATE)

amazing thanks @Gregory Jones worked like a charm 🙂

Awesome! No problem!