How to change format of entry date in calculated field

Forum|Forum|4 years ago
November 4, 2021
3 replies
891 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

skyehansen

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%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-data-expressions.html&_LANG=enus

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.

M

MichelleMc6Author

Level 3

Thank you again. I really appreciate your expertise! take care.

V

Vin01

Level 2

Hi @Michelle McAnelly‚, where you able to come up with a way to add a leading zero before the month & day? 01, 02, etc.

M

MichelleMc6Author

Level 3

Hi, I was not able to find a solution yet but would love to find one! Thanks, Michelle Michelle McAnelly Productivity Manager. Investment Strategy M 612 209 2226 MMcAnelly@paraport.com PARAMETRIC | 3600 MINNESOTA DRIVE | SUITE 325 | MINNEAPOLIS, MN 55435 parametricportfolio.com

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded