cancel
Showing results for 
Search instead for 
Did you mean: 

Formatting DateTime Columns in Story Analytics (Reporting Center)

skusulja
Explorer
252

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
alex_roman
Discoverer
0 Kudos

Hi,

Have you tried only this formula?

ToDate([Time Management#Recorded Time Data#Start Date])

thanks,