You are viewing limited content. For full access, please sign in.

Question

Get a date from a date time in Workflow

Workflow

Updated February 24

asked on February 23

Why doesn't this format work for extracting just the date? If I take out the parentheses it works, but Date Time field variables in Forms include this and I need to clean it up for inserting in a SQL database

0 0

Replies

replied on February 23

Because it's a string not a date due to having the timezone offset included. If you use "2/20/2026 12:00:00 AM", it will format as expected.

2 0

replied on February 24

Ok, I used a regex instead since Forms is sending over this string value with the offset from a Date Time field on the form.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked February 23
Updated February 24
165 views