Formating in to date time

[satish.rathi59 (Satish Rathi)]

str_ATADate = 09/May/2023
str_ATSDate = 08/Apr/2023

Want date difference 09/May/2023-08/Apr/2023= 31days

I have converted

Date_ATADate=DateTime.ParseExact(str_ATADate,“dd/MMM/yyyy”,System.Globalization.CultureInfo.InstalledUICulture)

And Date_ATSDate= Convert.ToDateTime(str_ATSDate).Date.ToString(“dd/MMM/yyyy”) while converting taking date_ATSDate = 01/Jan/0001 but want date_ATSDate= 08/Apr/2023

Tried both method

Date diff = DateDiff(DateInterval.Day,convert.ToDateTime(date_ATSDate),convert.ToDateTime(date_ATADate))
=738647 days which is wrong

Required answer is 31days

Some one help me on this.

[Harshith_Adyanthaya]

Hi @satish.rathi59,

DateDiff(DateInterval.Day,Cdate(“08/April/2023”),Cdate(“09/May/2023”))

This gives 31. If you don’t want to consider the existing dates then subtract 2.

In your equation it should be:

DateTime.ParseExact(str_ATADate,“dd/MMM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)

Try this.

Hope it helps.

[Anil_G (Anil Gorthi)]

@satish.rathi59

Please use this

System.Globalization.CultureInfo.InvariantCulture

Cheers

[satish.rathi59 (Satish Rathi)]

@Harshith_Adyanthaya

DateTime.ParseExact(str_ATADate,“dd/MMM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)

ATA Date is perfect want ATS Date accurate I am not getting using above

[satish.rathi59 (Satish Rathi)]

Thanks for you comment but not found solution

[Harshith_Adyanthaya]

Use InvariantCulture instead of InstalledUICulture.

If you are input date format is same as you mentioned, then you can just use CDate, need not use ParseExact.

[satish.rathi59 (Satish Rathi)]

@Harshith_Adyanthaya

DateTime.ParseExact(str_ATADate,“dd/MMM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)

I have tried the same but thrown exception

[Harshith_Adyanthaya]

Try this directly, No need of ParseExact.

DateDiff(DateInterval.Day,Cdate(str_ATSDate),Cdate(str_ATADate ))

[Manish540 (Manish Shettigar)]

Hi @satish.rathi59 ,

Check this below codes,

firstDate(DateTime as type) = System.DateTime.ParseExact("08/Apr/2023","dd/MMM/yyyy",System.Globalization.CultureInfo.InvariantCulture)

endDate(DateTime as type) = System.DateTime.ParseExact("09/May/2023","dd/MMM/yyyy",System.Globalization.CultureInfo.InvariantCulture)

totalDays(Int32 as type) = (endDate-firstDate).TotalDays

Screenshot:

Hope this might help you

[Anil_G (Anil Gorthi)]

@satish.rathi59

This is what I wanted you to try

DateDiff(DateInterval.Day,DateTime.ParseExact("24/Mar/2023","dd/MMM/yyyy",System.Globalization.CultureInfo.InVariantCulture),DateTime.ParseExact("03/Mar/2023","dd/MMM/yyyy",System.Globalization.CultureInfo.InVariantCulture))

cheers

[Nitya1 (Nitya Tomar)]

Hi @satish.rathi59

Try this code

string str_ATADate = “09/May/2023”;
string str_ATSDate = “08/Apr/2023”;

DateTime date_ATADate = DateTime.ParseExact(str_ATADate, “dd/MMM/yyyy”, System.Globalization.CultureInfo.InvariantCulture);
DateTime date_ATSDate = DateTime.ParseExact(str_ATSDate, “dd/MMM/yyyy”, System.Globalization.CultureInfo.InvariantCulture);

TimeSpan dateDiff = date_ATADate - date_ATSDate;
int daysDiff = dateDiff.Days;

Console.WriteLine(daysDiff);

[Arunkumarasokan1984 (Arun Kumar)]

In StudioX, you can try this Modify date option out of the box as well.