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

Question

Question

get year and month part of the field.

asked on March 3, 2015

Good afternoon,

I have a barcode that looks like this BC04-03022015-1639.49 and the part in between dashes is Bad Check Date. We created a field called Bad Check Date and formatted date to look like mm/dd/yyyy and that is working fine but now I would like to use year part from this field (4 digit long) in the folder path and right after that I would like to take month part and use it as a subfolder. Month needs to be in MMMM format.

So our path should be \Bad Checks\Year part\Month part\Department and finally document will be named using Bad Check Date. We have all of it working other than Year and Month part.

 

Thanks

 

 

Amir

0 0

Answer

SELECTED ANSWER
replied on March 3, 2015

The same formatting feature is also available in Quick Fields in the document class properties when you use tokens in the folder path.

0 0

Replies

replied on March 3, 2015

I am sure there are multiple ways to do this and mine may not be best.  Create a pattern match and create a day, month, and year token. 

.*\-(..)......\-.*  should get you the day

.*\-..(..)....\-.*  should get you the month

.*\-....(....)\-.*  should get you the year

 

You should be able to use those tokens to fill in what you need.

0 0
replied on March 3, 2015

If this value is now in a field you can use formatting in workflow. In your move activity go to token dialog 

For the year highlight the "Year Part" and then select your retrieve date field value.

Select "Apply Formatting and type in "yyyy" this will get you the year

For the month select the "Month part" of the folder path and then again select the retrieve field values only this time in formatting type in "MM". The case is important in order to get the right values. 

 

 

0 0
SELECTED ANSWER
replied on March 3, 2015

The same formatting feature is also available in Quick Fields in the document class properties when you use tokens in the folder path.

0 0
replied on March 4, 2015

I wasn't aware of this feature... it was super easy to do. Thanks Miruna!

 

 

Amir

0 0
replied on March 4, 2015

Thanks Miruna,

After I submitted I noticed the Quick Fields aspect of things

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

Sign in to reply to this post.