Is it possible to format the date as required on the Report view? | Community
Skip to main content
Srinija_N
Srinija_N
Level 7
September 12, 2025
Solved

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

  • September 12, 2025
  • 1 reply
  • 196 views

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!

 

Best answer by Srinija_N

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')

1 reply

Srinija_N
Srinija_NAuthorAccepted solution
Level 7
September 12, 2025

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')

Terms & ConditionsAccessibility statement

Loading footer...