Formatting DateTime fields to remove time

Hi Daniel,

Try using a Regular Expression with the following settings:

• String = Start Date field
• String operation = Replace
• Pattern = [0-9]+:[0-9]+:[0-9]+ [a-zA-Z]+
• Replacement string = empty
• Output = Text variable

Then use the text variable in your task email.

I would recommend creating text Workflow Variables "Start" and "End", and then setting these variables just before the task in your workflow using Set Workflow Variable and setting Start to the date format you wish by pressing on the orange fx button to pull-up the return type selection box:

You can then replace Start Date with the Workflow Variable "Start" in your email layout.

Shaun  /  Eric

I will look at your suggestions when I get in tomorrow. I think one of the team has made a change by setting string variables from both the Start and End dates with just the first 10 characters, and then using these vars in the email.  I wondered if there wasn't a way without creating yet more variables.

Oh well, I will update this post once I have tested .

Thanks again.

Daniel

Eric

Although, the workflow is pretty much completed. I thought I would tryout your suggestion on one of the .NET regex tools out there using a text string: 20/06/2016 00:00:00

.NET Regex Tester - Regex Storm

Unfortunately, I am not seeing a match.  In my case I wouldn't use a regex expression in my workflow unless I got a match using one of the tools.

Daniel

Hi Daniel,

The correct Pattern should be:  [0-9]+:[0-9]+:[0-9]+

Give that a try and let me know if that works.

Eric

Hello Daniel,

where you able to solve your issue, whit the hints of shaunlub​ or @eric

Thank you, regards

Oliver

Hi Daniel, did the suggested fix solve your issue?