# \[workflow\] Detect date in property value, and format it

**URL:** <https://community.hubspot.com/t/workflow-detect-date-in-property-value-and-format-it/46086>\
**Category:** Lists, Lead Scoring & Workflows\
**Tags:** workflows\
**Created:** [October 28, 2021, 9:40am UTC](https://community.hubspot.com/t/workflow-detect-date-in-property-value-and-format-it/46086 "2021-10-28T09:40:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Baduist](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/baduist/32/81360_2.png) [@Baduist](https://community.hubspot.com/u/Baduist)\
**Post date:** [October 28, 2021, 9:40am UTC](https://community.hubspot.com/t/workflow-detect-date-in-property-value-and-format-it/46086/1 "2021-10-28T09:40:07Z")

</div>

I have a workflow that changes the format of a property value.

The value contains a date, but with more text around it. I’m wondering if it’s possible to detect the date within the text, so that I can format it to a crtain date format.

(Also, is it possible to use regex or scripting to do this?)

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [October 28, 2021, 9:50am UTC](https://community.hubspot.com/t/workflow-detect-date-in-property-value-and-format-it/46086/2 "2021-10-28T09:50:29Z")

</div>

Hi @Baduist,

This is possible but requires custom code actions, available in Operations Hub Professional or Enterprise: [Workflows | Custom Code Actions - HubSpot docs](https://knowledge.hubspot.com/workflows/use-custom-code-actions-in-workflows)

Best regards!