Convert string of "DD-MMM-YYYY" to datetime and find difference

[arina]

How to convert “24-JAN-2024” to datetime and find difference between it and current date?

[THIRU_NANI (NaNi)]

Hey!

If Your input date is → “24-01-2022”

Try like this

Cdate(Input).ToString("dd-MMM-yyyy")

If you wants to find the difference between the dates:

DateDiff(DateInterval.Day, DateTime.ParseExact(Input.ToString, "dd-MMM-yyyy", System.Globalization.CultureInfo.InvariantCulture),DateTime.now())

Try this and let me know

Regards,
NaNi

[ppr (Peter)]

we can parse the string into a DateTime with the help of ParseExact

myDate = DateTime.ParseExact(strDateVar, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture)

then we can subtract the date from Now.Date which is similar to Today and will get back a TimeSpan