94

Our client is having a business requirement to have end dates which some are 999 years in length.


There is currently a limit on the date to field to only allow up to 31/12/2154.


Their business process uses the dates from the Leases on the buildings they handle for reporting purposes and since there is a limit on the End date, the reports cannot reflect correctly the information, which interferes with the normal process.


We would like to ask for your vote for this Idea so we can show to the Product Team this extension is needed for the normal daily business of the client.


Start and End date are hardcoded into the system and we couldn't achieve this with customization, so we require help from Microsoft.

Category: Asset Leasing
STATUS DETAILS
New

Comments

S

Surely the underlying database (SQL Server) isn't the cause here because the maximum unless you are using smalldatetime is 9999-12-31. I understand there will be remediation for existing customers that rely on it being 2154 so perhaps you could make this configurable so those customers not wanting to be locked into the artificial limit of 2154 can freely use up to 9999-12-31 as the underlying database technology supports?

Category: Asset Leasing

S

Needed by anyone managing property leases.

Category: Asset Leasing

S

Essential for business that operate with housing leaseholds which can be 999 years

Category: Asset Leasing

S

Great idea!

Category: Asset Leasing

S

Voted

Category: Asset Leasing