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

Question

Question

How do I get a date token that is set up like 07/20/2022 in workflow?

Workflow
Updated July 20, 2022
asked on July 20, 2022

I've been toying with this process for a bit but I can't seem to get the token to show up as 07/20/2022, currently, I'm using %(Date#"MMddyyyy"#) but that gives me 7202022, added slashes to it doesn't seem to correct this.

For the process this is for, I need it to show up as 07/20/2022 specifically, any idea on how to get that to show up properly in a token?

0 0

Answer

SELECTED ANSWER
replied on July 20, 2022 • Show version history

Ah, that was my mistake

You would enter MM/dd/yyyy in the formatting field of the token editor, but in the actual token the / would be escaped.

 %(Date#"MM//dd//yyyy"#) 

1 0

Replies

replied on July 20, 2022 • Show version history

You need to explicitly include the slashes in the formatting if you want them.

MM/dd/yyyy in the formatting field

The result would be: %(Date#"MM//dd//yyyy"#)

Token Formatting--Date and Time (laserfiche.com)

EDIT: Forgot to include the escapes in the resulting token string.

2 0
View 2 previous replies
replied on July 20, 2022

Using %(Date#"MM/dd/yyyy"#) still returns a date of 07202022 for some reason.

0 0
replied on July 20, 2022

That doesn't sound right. I use that same formatting in dozens of workflows, so there has to be something else going on.

Where are you using that token value? What do you see when you test it?

1 0
replied on July 20, 2022

I'm making the token normally and then it's used when writing information to a spreadsheet, however even before writing the date to the spreadsheet it shows up wrong in track tokens.

0 0
SELECTED ANSWER
replied on July 20, 2022 • Show version history

Ah, that was my mistake

You would enter MM/dd/yyyy in the formatting field of the token editor, but in the actual token the / would be escaped.

 %(Date#"MM//dd//yyyy"#) 

1 0
replied on July 20, 2022

That works great!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...