Formula Date Not Syncing With Conditional Formatting

Hi, I'm trying to automate my start date and due date columns. In order to do this, I'm essentially hard coding the month and day piece of the function (e.g. "01/01") and then extracting the annual piece of the function from the Task column (e.g. "2024" to "24"). The output, I believe, is similar as it would be in excel and is being recognized as a "text" format, as opposed to a date format. As a result, the Gantt chart is not picking it up nor is that value able to be used in my standing formula (as shown below).

My question, then, is there a formula or way to convert this text format into a date format so that my formulas work appropriately?

Find more posts tagged with

Formulas

dates

Accepted answers

Matt Lynn ACT

@aaronh123 Yes, when you use a formula like the right() it does convert it to text and loses the date functionality. You would bury that into a date() formula to keep the date functionality.

Try this:

=DATE(VALUE(RIGHT(Task@row, 2)), 1, 1)

All comments

Matt Lynn ACT

@aaronh123 Yes, when you use a formula like the right() it does convert it to text and loses the date functionality. You would bury that into a date() formula to keep the date functionality.

Try this:

=DATE(VALUE(RIGHT(Task@row, 2)), 1, 1)

aaronh123

Thanks Matt,

That worked very well for us, thank you!

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.