When I work with contracts, accruals, forecasts etc, I often have to calculate the duration of the contract, or in general the difference between two dates. I have been using an ordinary datediff in Months, as this is the fastest way, to get the duration of a contract in months.
This is just a quick post for, with a old method for fetching the row count for a entire database – for future reference (Works in Azure – doesn’t require stored proc)
When using multifactor authentication for your Dynamics 365, it tends to cause issues with the KingswaySoft connector, as MFA is not supported by their toolkit. Therefore – as an alternative to disabling the MFA...