Lightswitch difference between two dates in months (VB) does not have to be exact
Posted on 2013-06-27
I have two date entries that are filled out with random dates (datfields). I want to compute the time between two dates in months. Dividing the days by 30 is fine does not have to be exact. The computed field is a String. Not sure if this matters or if it would be better as an integer.
I know the following is not correct, but it should give some type of idea of what I am trying to do.
If Not StartDate Is Nothing And Not EndDate Is Nothing Then
result = (StartDate - EndDate) /30