How to calculate the length of a date to the present date

Help Activities
, , ,
1

Hi All,

I need to find out how many months and years are between a specific date and the present date. For example, this is the format of the date July 16, 2019 to the present date. I need to calculate how many months and years there are in the difference. The date will change so I would need a dynamic expression to work.

Thank you!

2

@Lisa_O
Find starter help here:
CalcDiff_YearMonthTotalMonth.xaml (6.0 KB)

Parsing this format can be done as below:

grafik
grafik924Ɨ51 14.9 KB 

DateTime.ParseExact("July 16, 2019","MMMM dd, yyyy", CultureInfo.InvariantCulture)
1 Like
3

Hi, thank you for your response.

When trying to use DateTime.ParseExact(strDate, ā€œdd.MM.yyyyā€, CultureInfo.InvariantCulture) I am getting the following error message, ā€˜CultureInfoā€™ is not declared. Would you know the reason why I am getting this?

Thank you!

4

@Lisa_O
ensure following:
grafik

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.