topic Re: how to calculate due date based on created date and estimated time in App Development

how to calculate due date based on created date and estimated time

dandaanilreddy — Thu, 07 Jul 2022 12:27:05 GMT

Hello All,

I have created date for each ticket in date format 'DD/MM/YYYY' and estimated time to resolve the ticket in seconds. I need to create due data based on created date and estimated time. Please can someone let me know how to create due date based on these 2 fields.

Thanks

Re: how to calculate due date based on created date and estimated time

Or — Thu, 07 Jul 2022 13:39:06 GMT

CreateDate + (EstimateTime/(60*60*24))

Math with dates is fairly simple - 1 = one day, so you just need to convert the seconds.

Re: how to calculate due date based on created date and estimated time

dandaanilreddy — Thu, 07 Jul 2022 13:21:53 GMT

Hello

Thank You for the response. My requirement is to calculate the due date based on created date and estimate time (coming as seconds from DB).

Example: Ticket created on 28/04/2022 and estimated time is 57600 seconds. so for this ticked based on the estimate time i want to see due date as 02/05/2022 excluding weekends.

Note: I'm looking only for working hours which is converted to seconds as 28800 ( for 8 hrs) ( 57600/28800)= 2 days.

Thanks

Re: how to calculate due date based on created date and estimated time

Or — Thu, 07 Jul 2022 13:38:36 GMT

Well, that's a completely different question right there...

I don't know of any built-in way to get an "inverse" networkdays(), but have a look at this thread for a possible solution:

https://community.qlik.com/t5/QlikView-App-Dev/Date-Calculation/m-p/348807