Is it possible to format the date as required on the Report view?

[Srinija_N]

Can we set the format of a date field(standard or custom or Calc date field) to YYYY-MM-DDThh:mm:ss.fffZ on a report using advanced text mode?

I see only below field formats available under advanced options. The one I am looking for is not available by default. 

Can someone please advise on this?

Currently we are trying this on a report the normal way, later we want to integrate AEM with Workfront to auto-populate this field from AEM. will there be any issue or impact later with this integration on this field formats?

TIA!

[Srinija_N · Accepted solution]

Found the solution myself.

Sharing the text here just for information.

valueexpression=CONCAT(YEAR({plannedStartDate}),'-',IF(MONTH({plannedStartDate})<10,CONCAT('0',MONTH({plannedStartDate})),MONTH({plannedStartDate})),'-',IF(DAYOFMONTH({plannedStartDate})<10,CONCAT('0',DAYOFMONTH({plannedStartDate})),DAYOFMONTH({plannedStartDate})),'T',IF(HOUR({plannedStartDate})<10,CONCAT('0',HOUR({plannedStartDate})),HOUR({plannedStartDate})),':',IF(MINUTE({plannedStartDate})<10,CONCAT('0',MINUTE({plannedStartDate})),MINUTE({plannedStartDate})),':',IF(SECOND({plannedStartDate})<10,CONCAT('0',SECOND({plannedStartDate})),SECOND({plannedStartDate})),'.',IF(MILLISECOND({plannedStartDate})<10,CONCAT('00',MILLISECOND({DE:Announcements Send Date Time})),IF(MILLISECOND({plannedStartDate})<100,CONCAT('0',MILLISECOND({plannedStartDate})),MILLISECOND({plannedStartDate}))),'Z')