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

Question

date conversion

Quick Fields Version 9 How To

Updated August 28, 2017

asked on August 24, 2017

I need to convert dates from an invoice into our standard format. I am not sure how to convert dates like:

18-aug-17

Aug 18, 2017

into mm/dd/yyyy format.

I thought about using patterns but not sure that would work. Is there some sort of function I can use?

Thanks in advance for your help!

0 0

Answer

SELECTED ANSWER

replied on August 25, 2017 • Show version history

Hi Brandon,

You can format date tokens in the Token Editor for both of these date format (18-Aug-2017 or Aug 18, 2017).

The specifier I used is "d," but note that this short date pattern is defined in my Workflow Server computer's regional settings. Otherwise, you can just type in "MM/dd/yyyy" to specify the format.

1 0

Replies

replied on August 26, 2017

Thank you that worked!

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked August 24, 2017
Updated August 28, 2017
179 views