Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Difference between two timestamps in SAP Analytics Cloud

Former Member

on ‎2019 Jul 02 5:10 PM

1,280

Hi,

I need to calculate the difference between two timestamps in a model in SAP Analytics Cloud.

For context, during data import, I set some columns to "Timestamp" as the hour and minute information is important and will be discarded if imported as "Date". I know that there is a DATEDIFF function available to calculate the difference between two dates. Is a similar function available for timestamps? Currently, it does not seem like the DATEDIFF function is applicable to timestamps.

I appreciate your help!

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
ironjan
Participant
‎2020 Jan 23 10:31 AM
0 Likes

Nobody ever done this before? How to calculate the difference between two time stamps. Seems rather important: how long has croissant been in the oven, how many hours has someone worked...

Those questions I need to solve in SAP Analytics Cloud on data import model.

Tx,

Jan

Accepted Solutions (0)

Answers (0)

Ask a Question