Skip to content
+1-888-319-3663

COMMUNITY FORUM

Changing Format of Document Date

Dominique asked 3 years ago
I’m trying to use a calculated column to create a Batch Number.
I’d like the Batch Number to include the _DOCDATE source column.
It’s currently formatted as 2/5/19 but I’d like it to be 190205 in the Batch Number.
The date is a variable and will change with each new file that is uploaded.
What’s a simple way to format this?
 
Thanks,
D
Answers
Patrick Roth Staff answered 3 years ago
Simple way is to use the Additional Column | Date Calculation Column window.
Define a new format as the “Source” to be: M/d/yy
define a new format as the “Target” to be yyMMdd
Then give use your _DOCDATE as the source data.
SC will translate the 2/5/19 -> 190205 for you
Dominique replied 3 years ago

I was making that much more difficult than it needed to be. Thank you!


If you would like to submit an answer or comment, please sign in to the eOne portal.