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 @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
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 | |
3 | |
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.