question Re: Unable to convert date to a particular format in Support Questions

Unable to convert date to a particular format

rafy — Tue, 21 Apr 2026 07:51:31 GMT

Hello, please kindly help. i am trying to convert a datetime(attribute) from one format to the other but it keeps giving me empty value on the attribute:

SCENERIO:
Flowfile is json----->extract date from Json flowfile using Evaluatejsonpath---->format date using Updateattribute

Actual Date: "2022-08-01 00:00:00.0"

Desired date: "01/08/2022 00:00:00.000000"

I have tried to use this on the updateattribute, but it is not working:

${DATE_TIME:toNumber():toDate('yyyy-MM-dd hh:mm:ss.S'):format('dd/MM/yyyy HH:mm:ss.SSSSSS')}

Thank you.

Re: Unable to convert date to a particular format

araujo — Thu, 11 Aug 2022 10:58:49 GMT

@rafy

Try this:

${DATE_TIME:toDate('yyyy-MM-dd HH:mm:ss.SSSSSSSSS'):format('dd/MM/yyyy HH:mm:ss.SSSSSS')}

Cheers,

André

Re: Unable to convert date to a particular format

rafy — Thu, 11 Aug 2022 12:16:47 GMT

Thank you sir. It works.