How to record date without time

I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation?

If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into separate columns?

Find more posts tagged with

Formulas

functionality

Automations

timestamp

dates

Accepted answers

All comments

Darla Brown

Hi, @Alex Hackford,

If you are using the Record a Date automation, it will show the date only. If you are using Modified Date or Created system columns, it will show the time stamp.

Hope this helps.

Alex Hackford

Thanks! I mixed up the automated column and the created date column!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.