calculate the number of days between two dates

[mta]

In Zennoposter , i need to calculate number of days between 2 dates and put the result in a variable. Is there anyway to do it in ZP without coding? If not can someone help me by a snipet, i 'am not a coder

 

[Phoenix78]

DateTime date1 = DateTime.ParseExact("2020-10-16 2-06-39--325", "yyyy-MM-dd H-mm-ss--fff", CultureInfo.InvariantCulture);
DateTime date2 = DateTime.ParseExact("2020-10-14 2-06-39--325", "yyyy-MM-dd H-mm-ss--fff", CultureInfo.InvariantCulture);

int days = (date1 - date2).Days;
return days;

 

[mta]

Great! thanks! But i used this DateTime.Parse for counting Days only.

DateTime date1 = DateTime.Parse(project.Variables["v1"].Value);
DateTime date2 = DateTime.Parse(project.Variables["v2"].Value);

int days = (date2 - date1).Days;
return days;

Now i 'am wondering how to manage date format. My date format stored in variable is dd/MM/YYYY and environnemental variable of zennopster is MM.dd.YYYY. Some Tips ?

 

[nicanil]

On this page you can find available format specifiers and their description.

Code for formats described in your message:

DateTime mta_date = DateTime.ParseExact("02/03/2020", "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
DateTime zp_date = DateTime.ParseExact("03.09.2020", "MM.dd.yyyy", System.Globalization.CultureInfo.InvariantCulture);

int days = (mta_date - zp_date).Days;
return days;

 

[mta]

On this page you can find available format specifiers and their description.

Code for formats described in your message:

DateTime mta_date = DateTime.ParseExact("02/03/2020", "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
DateTime zp_date = DateTime.ParseExact("03.09.2020", "MM.dd.yyyy", System.Globalization.CultureInfo.InvariantCulture);

int days = (mta_date - zp_date).Days;
return days;

Great !!! Thanks

 

[mta]

hello !

I get an error while converting date in good format:

Compiling code of Error in action "CS1503" "Argument 3: cannot convert from 'System.Globalization.CultureInfo' to 'System.Globalization.DateTimeStyles'". [Row: 13; Column: 91]

System.Globalization.CultureInfo culture = System.Globalization.CultureInfo.CreateSpecificCulture("fr-FR");
DateTime date1 = DateTime.Parse(project.Variables["v1"].Value, "dd/MM/yyyy", culture);
DateTime date2 = DateTime.Parse(project.Variables["v2"].Value, "dd/MM/yyyy", culture);

int days = (date2 - date1).Days;

return days;

 

[nicanil]

hello !

I get an error while converting date in good format:

Compiling code of Error in action "CS1503" "Argument 3: cannot convert from 'System.Globalization.CultureInfo' to 'System.Globalization.DateTimeStyles'". [Row: 13; Column: 91]

System.Globalization.CultureInfo culture = System.Globalization.CultureInfo.CreateSpecificCulture("fr-FR");
DateTime date1 = DateTime.Parse(project.Variables["v1"].Value, "dd/MM/yyyy", culture);
DateTime date2 = DateTime.Parse(project.Variables["v2"].Value, "dd/MM/yyyy", culture);

int days = (date2 - date1).Days;

return days;

Because you use DateTime.Parse and this method doesn't take CultureInfo as the third argument. You should use DateTime.ParseExact instead.

System.Globalization.CultureInfo culture = System.Globalization.CultureInfo.CreateSpecificCulture("fr-FR");
DateTime date1 = DateTime.ParseExact(project.Variables["v1"].Value, "dd/MM/yyyy", culture);
DateTime date2 = DateTime.ParseExact(project.Variables["v2"].Value, "dd/MM/yyyy", culture);

int days = (date2 - date1).Days;

return days;

 

[mta]

Because you use DateTime.Parse and this method doesn't take CultureInfo as the third argument. You should use DateTime.ParseExact instead.

System.Globalization.CultureInfo culture = System.Globalization.CultureInfo.CreateSpecificCulture("fr-FR");
DateTime date1 = DateTime.ParseExact(project.Variables["v1"].Value, "dd/MM/yyyy", culture);
DateTime date2 = DateTime.ParseExact(project.Variables["v2"].Value, "dd/MM/yyyy", culture);

int days = (date2 - date1).Days;

return days;

Great, thanks i will never be able to handle this mistake alone !