Question

Date Token format in Import Agent

Import Agent

Updated September 26, 2022

asked on June 26, 2017

Can anyone advise whether it is possible to change the date format that the token outputs in Import Agent. We have a client with an issue where for some reason their date format does not follow their system locale format, and changing it on the OS does not work either. They are using Windows Server 2013 R2, and the date format is set to using UK (dd/MM/yyyy) under the OS, which is the format they would like to achieve. Thanks.

0 0

Answer

SELECTED ANSWER

replied on June 27, 2017

Hi Wai Kit Lam,

The token format can be specified as the following %(DateToken,Format), for example, %(Date,MM/dd/yyyy). The feature is available in Import Agent 10

2 0

View 2 previous replies

replied on June 28, 2017

Good morning Huazhen,

Thanks for explaining this, this is very useful to know.

I was unable to find this documented in the "Import Agent" chapter of the Administration Guide--is there a list of all available token formats for Import Agent?

Thank you,

Rob

0 0

replied on June 28, 2017

Hi Rob,

The format can be customized depending on your request. We didn't mentioned the token format in the help documentation, but we will add a section for it. Thank you for the reminder. But for now, you can reference http://userguide.icu-project.org/formatparse/datetime. Basically, you can combine the symbols with other characters to get a format. When formatting, the symbol will be replace with the value, while other characters will be kept. Take MM/dd/yyyy as an example, MM will be replaced with the month, dd the day, yyyy the year, / will be leaved as it is.

1 0

replied on June 29, 2017

Hi Huazhen,

Great--thank you for the link! Is it possible to format IA tokens other than dates? Similar to the way one would format at token in Workflow via either the Token Editor or syntax mastery?

Thank you,

Rob

0 0

replied on June 29, 2017

Hi Rob,

Import Agent 10 supports formatting tokens in date/datetime/time/number, such as %(Date), %(DateTime), %(Time), %(Count). It doesn't support string manipulation or regular expression in Workflow.

1 0

replied on September 26, 2022

Update to this... dont use %(Date,dd-MM-yyyy) you need to use %(Date;dd-MM-yyyy)

you need to use semicolon

0 0

Replies

replied on June 27, 2017

Hello Wai Kit Lam,

Does your client want the leading 0? As far as I can tell, the "dd/MM/yyyy" format is the default format for Date fields generally and for Import Agent specifically.

Unfortunately I don't have any advice for formatting the token within Import Agent--is anything happening with the documents after they're picked up by Import Agent? If they're being routed by a workflow, perhaps you could try reformatting the token in the workflow. If they're not being handled by a workflow, perhaps you could create a workflow for the sole purpose of formatting the date of documents brought into the repo by Import Agent?

Good luck,

Rob

0 0

You are not allowed to follow up in this post.

Question

Question

Date Token format in Import Agent

Answer

Replies

Sign in to reply to this post.