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
  • 201 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!

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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...