Date Find

Hi Team,

I have 2 dates say

RepaymentDate=04Mar2020 - String
CurrentDate=01Apr2020 - String

How to find the date difference am using as
DateDiff(DaterInterval.Day,RePaymentDate,CurrentDate) - i am getting err. Help needed

You can only use DateDiff on Datetime objects, whereas yours are strings.

So you’ll need to use

DateDiff(DaterInterval.Day,Datetime.ParseExact(RePaymentDate, "ddMMMyyyy", System.Globalization.CultureInfo.InvariantCulture),Datetime.ParseExact(CurrentDate, "ddMMMyyyy", System.Globalization.CultureInfo.InvariantCulture))

Getting error - Disallows implicit conversions from long to string
It has been assigned to a string, need to change that ?

Team anybody help me out in solving the above error ?

DateDiff.xaml (4.7 KB)

Check this…!

Thanks! @Balan

Its working fine thanks