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

[dandaanilreddy]

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

[Or]

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

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

[dandaanilreddy]

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

[Or]

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