计算VB.NET的天数百分比

Question

如何使用VB.NET计算完成天数的百分比？

datareader采用project_start和project_finished，在SQL-Server-2012中存储为Date()。

这是我尝试过的：

Dim StartDate As New Date(datareader("project_start"))
Dim FinishDate As New Date(datareader("project_finish"))
Dim Percentage As Date = Date.FromOADate(StartDate.DayOfYear) / Date.FromOADate(FinishDate.DayOfYear) / 100

但是我得到了这个错误：

Operator '/' is not defined for types 'Date' and 'Date'.

Answer 1

您需要减去日期并使用TotalDays属性。示例代码如下：

Dim start As DateTime = DateTime.Now.AddDays(-50)
Dim endDate As DateTime = DateTime.Now.AddDays(50)

Dim today As DateTime = DateTime.Now

Dim sumDays = (endDate - start).TotalDays
Dim daysToNow = (today - start).TotalDays

Dim percentage = daysToNow / sumDays * 100

Console.WriteLine(percentage)

Console.ReadLine()