Hello everyone,
im developing reactive web app.
i need to find difference between dates between two datetime attributes.
so that if manager approves in the same date then i should get decimal value like with hour or if manager approves in minutes i should get decimal value.
im using diffdays() but if manager approves on same day im getting zero value. instead of this based on time i should get some value.
can someone help me here.
Regards.
Hi Salman,
You can use DiffDays() and if it is 0, you check DiffHours(). And if it is 0, you check DiffMinutes(). Something like in the logic flow below:
If you want to get in decimals, like 0.5 days, you just need to divide the number of hours by 24, and divide the minutes by 60, to get its amount in hours.
Now that you have the tools, you just need to articulate the logic to your precise use case.
Kind Regards,João
Hi ,
Thanks for responding.
im working in aggregate. pls check below snippet whether its correcet or not . im not getting value pls check below snippet.
Please find attached oml. Implemented in the same way as suggested above by @João Marques
You can change it as per your use case.
Thanks.
hi ajit,
thanks for responding. but its my mistake.
im working in aggregate.. im using below to get days pls check if its correct or not.