Hello,
I'm working on creating a custom project code that uses the entry date as part of it. I got this calculation to work
CONCAT((Entry Date),"-",Reference Number,"-",Queue Topic code)
but the formatting of the date came in with this format 11/2/21 and I need it to be just numbers without the back slashes and read 11221 or even better 110221. Does anyone know of a way to do this? The output currently looks like this:
11/2/21-123456-CC but I want 110221-123456-CC
I appreciate any help!
Thanks,
Michelle
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
there's not a way to easily do this, so you'll just have to build one with the link I sent you yesterday: https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FRe...
In particular the YEAR, MONTH, DAYOFMONTH, and (probably) the RIGHT commands. You'll also probably need LEN if you can't let go of that starting zero, so I'll leave it up to you.
Views
Replies
Total Likes
Thank you again. I really appreciate your expertise! take care.
Views
Replies
Total Likes
Hi @Michelle McAnelly‚, where you able to come up with a way to add a leading zero before the month & day? 01, 02, etc.
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Likes
Replies