on 2025 Jan 07 1:17 PM
In the Reporting Center, using Story Analytics, is there a straightforward way to format DateTime columns?
For example:
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:
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.
Request clarification before answering.
Hi,
Have you tried only this formula?
ToDate([Time Management#Recorded Time Data#Start Date])
thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.