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?

2 Answers 2


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.


I have discovered a simple way of formatting Date field in SharePoint to exclude time stamp.

I opened the list in SharePoint Designer and open the properties of the list. Select Formatting and deselect Time.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.