cancel
Showing results for 
Search instead for 
Did you mean: 

Formatting DateTime Columns in Story Analytics (Reporting Center)

skusulja
Explorer
288

In the Reporting Center, using Story Analytics, is there a straightforward way to format DateTime columns?

For example:

  • In the Recorded Time Data table, the Start Date column is displayed as: Jan 1, 2025 1:00:00 AM (I want only the date part).
  • Similarly, the Start Time column is displayed as: Jan 1, 1970 09:00:00 AM (I want only the time part).

Both columns are formatted as DateTime by SAP.

I’ve tried using the ToDate function, but it doesn’t work and throws the following errors:

  1. ToDate([Time Management#Recorded Time Data#Start Date], "yyyy/dd/MM")
    • Error: Formula could not be computed: Function "ToDate" expects parameter 1 to be of type String. Please complete or rewrite the formula.
  2. ToDate("[Time Management#Recorded Time Data#Start Date]", "yyyy/dd/MM")
    • Error: Internal error occurred while processing.

I also attempted several other approaches, including nested functions with If, Concat, and SubString, but none of them resolved the issue.

Is there a simple or recommended approach to extracting only the date or time from these DateTime columns? Any advice would be greatly appreciated.

View Entire Topic
subbareddyven
Product and Topic Expert
Product and Topic Expert

Hi @skusulja ,

To fetch only date try like below

TODATE(CONCAT(TOTEXT(YEAR([Date] )) ,
CONCAT("/" , CONCAT(TOTEXT(MONTH([Date] )) ,
CONCAT("/" ,TOTEXT(DAY([Date] )) ) )) ), "yyyy/mm/dd" )

Regards,

Subbu

skusulja
Explorer
0 Kudos
This is the one, thank you