Date Difference Issue

Hi,

I tried using datediff function for getting date difference but I am getting issues

DateDiff(DateInterval.Day,convert.ToDateTime(strDate),DateTime.now())

Please find error below
image

Hi,

Can try the following expression?

DateAndTime.DateDiff(DateInterval.Day,Convert.ToDateTime(strDate),DateTime.Now,FirstDayOfWeek.Sunday,FirstWeekOfYear.Jan1)

Regards,

Hi @Shreya_Rao1,

Please try this expression in writeline:

DateDiff(DateInterval.Day,DateTime.ParseExact(strDate, “dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture),now).ToString

Thanks!