Question

1
Replies
1492
Views
Close popover
Sripada Venkata Aditya (SVAQuest)
Tata Consultancy Services Ltd
Technical Architect
Tata Consultancy Services Ltd
AU
SVAQuest Member since 2012 88 posts
Tata Consultancy Services Ltd
Posted: November 27, 2017
Last activity: November 28, 2017
Closed

Report Definition - Function Alias - The difference in days - to get the outputs in decimal instead of rounded down to nearest day

Hi All,
Function: The difference in days between .pxCreateDateTime and .pyResolvedTimestamp
Function Description: Returns the difference between two Date or DateTime values (the second minus the first) in days, rounded down (rounded for ORACLE) to the nearest day

Currently the function is working as expected, but how to get the exact the difference in days like 2.5 instead of 2 or 3?
Any Suggestions?

Reporting
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.