Date column showing as “Date and Time” even though “Date Only” selected

Question

In a workflow I have set up on a list, the email that is generated is showing a date with both date and time, with the time at 12:00:00 AM (using a lookup of one of the list's columns). Checking the source list, the column is of type Date, and the Date Format is set to "Date Only". Checking under the List Settings -> Column Types, the field's type shows as "Date and Time". Is there a way to fix this?

Answer 1

It sounds like the issue is within your workflow "Add or Change Lookup" settings. When you add the Lookup, make sure you choose >> Current Item >> Column/Field Name >>"RETURN FIELD AS" -Here you can select "SHORT DATE" if you want the time to be removed.