Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
CreateDate + (EstimateTime/(60*60*24))
Math with dates is fairly simple - 1 = one day, so you just need to convert the seconds.
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
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