I want to calculate number of working days between two dates (record field) and use the output as a custom field in the record. Getting stuck while trying to use calworkDays in a!customFieldDateDiff function. Can anyone please help
Discussion posts and replies are publicly visible
You can use the calworkDays() function in a sync-time custom record field.
Hi Stefan thanks for your response but in my use case I need to calculate workdays between a record field and today's date.. So cant do it in sync-type custom record field can you please suggest any possible solution to do this in real time custom record field.
I think this is not supported at real time.
okay stefan, is there any other way round , The exact use case is that user will enter number of days a case is open in the interface, then we need to query all the cases present in the record which are open for the entered number of days excluding the weekends and holidays based on "created On" date-time type field which is present in record.
For example if the user enters 5, then we need to return all cases which are opened for 5 business days.
Can this be done using a!queryRecordType in the interface itself.
Then, why not take that number entered by the user, add it to the current date respecting business days and store that. Then this would work like a due date.
a!queryFilter( field: 'recordType!{95b6b60f-3baf-445b-8ac8-ad1c6aabc820}CMS Cases.fields.{d29ddafb-ab89-4da7-8e24-13e050f348cd}createdOn', operator: "between", value: { datetime( year(today() - ri!busniessDaysOpenFilter-1), month(today() - ri!busniessDaysOpenFilter - 1), day(today() - ri!busniessDaysOpenFilter - 1), ), datetime( year(today() - ri!busniessDaysOpenFilter ), month(today() - ri!busniessDaysOpenFilter ), day(today() - ri!busniessDaysOpenFilter ), ) }, applyWhen: a!isNotNullOrEmpty(ri!busniessDaysOpenFilter)
This is how I have done it now it is working properly except it is taking weekends also.
Can you please explain this with any code snippet
Hi Stefan, any possible solution??
Hey there is an update in the use case, If I filter by Business days=4, then this would mean that only the cases which have been open for 4 business days would come in the filter result and if the case is created on weekends then it should not take the weekend while calculating the business days for ex. If case is opened on Saturday, and the filter is applied on Tuesday, then the business days open for that case would be 2 i.e. Mon & Tue.
Mike Schmitt Is there any possible way to solve this.
Also this filter is to be done on an interface which would then populate the case details from the record.