手机合约计算 [英] Cellphone contract calculation

问题描述

我很难计算手机合同的终止时间.我正在使用ADO.NET将所需的值放在该可指定的列中.我有一个 DateAcquired 字段，我可以手动输入数据.因此，该数据必须在 UpgradeDate 字段中自动显示，并提醒您在合同到期前 3个月显示.合同为 24个月.我只是在寻求与此代码的帮助.是一个基于Web的程序.

I have some difficulty of calculating the end of cellphone contract. I am using the ADO.NET to put the required value in that specifiable column. I have a field for the DateAcquired which I enter data manually. So that data must be shown automatically in the UpgradeDate field with an alert of showing 3 months before the contract expires. The contract is 24 months. I''m just seeking help with this code. Is a web based program.

推荐答案

您可以通过两种不同的方法进行计算:
1)在代码中: DateAdd函数 [ DATEADD函数 [

You can calculate it in two different ways:
1) in the code: DateAdd function[^].
2) in the SQL query: DATEADD function[^]

这篇关于手机合约计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！