date diff with calender in storedproc

Question

Hi Everyone, 
 I have a use case where I need to get the date difference between two dates ; but using the calender available in Appian. Due to some performace issues, all date differences I am doing in stored procedure and calling the same from Appian to get the value. But If I have to consider Appian calender, how to pass to the stored proc, so it will provide me the correct date difference considering the calender. 
 Regards, 
 Ghanashyam

Stefan Helzle · Answer

I do not see a direct way to extract the off-times from an Appian calendar. Did you consider to create a separate table in DB that stores this calendar data and use that?

Mathieu Drouin · Answer

You have two options: 
 1. Process the data in Appian and use the Appian provided calendar functions. 
 2. If you can't get around the Stored Procedure requirement, there are databases that allow you call to call REST apis, you could expose the Appian calendar functions via an API. 
 Is there any specific reason you need to use a stored proc for this rather than just creating an Appian process?