Custome DateTime Format

Hi @Prineel_V3 

First, use the “Format Date to String”. Store value into variable.

Next, apply Regex (Regular Expression) on that string to format into your required formatting  

Hi @Garrett ,

I did also attempt this, but there are no valid/usable operations to convert a datetime variable to a custom format (I could be doing something wrong though)

Sounds like a good enhancement request to me!  I can’t think of a good reason why the “Format date to string” action shouldn’t be able to take a custom format - just like the formatDate function in a form. 

As a side note, I did try to use an autocompleting form to convert a datetime variable to a custom format, but it looks like autocompleted forms don’t evaluate any variables within them.

Thanks @Garrett 

@Garrett  Thank you for providing the regex solution above. Can you help me to convert format “dddd, dd MMM YYYY” to US format “dddd, MMM dd YYYY” please? I cannot figure out the pattern and replacement text if I want “Monday, 22 May 2023” to display as “Monday, May 22, 2023”. 

Hi @jleung 

Here you go

Pattern:
(\w+,) (\d{2}) (\w+) (\d{4})

Replacement Text:
$1 $3 $2, $4

Testing

Date     : Sunday, 01 Jan 2023
Formatted: Sunday, Jan 01, 2023

Date     : Wednesday, 18 Jan 2023
Formatted: Wednesday, Jan 18, 2023

Date     : Friday, 28 Apr 2023
Formatted: Friday, Apr 28, 2023

Date     : Monday, 22 May 2023
Formatted: Monday, May 22, 2023

@Garrett  this works really nice! Thanks so much for your help!