Two Dates comparision Failing

Help Activities
, ,
1

Experts - Need help; What wrong in the below condition.

Using below in IF statement and always its going to ELSE block. Not sure what’s wrong here.

CInt(str_RptProviderCode.ToString.Trim.TrimStart.TrimEnd) = CInt(in_ProviderCode.ToString.Trim) AND DateTime.ParseExact(str_ReceiptDate.ToString.Trim.TrimStart.TrimEnd, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture) = DateTime.ParseExact(in_ReceiptDate.ToString.Trim, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture) AND DateTime.ParseExact(str_ServiceDate.ToString.Trim.TrimEnd.TrimStart, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture) = DateTime.ParseExact(in_ServiceDate.ToString.Trim, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture)

Values are as follows:
str_RptProviderCode = 00022; in_ProviderCode = 00022
str_ReceiptDate = 5/30/2022 ; in_ServiceDate = 05/30/2022
str_ReceiptDate = 10/6/2022 ; in_ReceiptDate = 10/06/2022

2

Hi @KrishnaKishore

Try the below syntax in If condition. I have made the required changes:

CInt(str_RptProviderCode.ToString.Trim.TrimStart.TrimEnd) = CInt(in_ProviderCode.ToString.Trim) AND DateTime.ParseExact(str_ReceiptDate.ToString.Trim.TrimStart.TrimEnd, "M/d/yyyy", System.Globalization.CultureInfo.InvariantCulture) = DateTime.ParseExact(in_ReceiptDate.ToString.Trim, "M/d/yyyy", System.Globalization.CultureInfo.InvariantCulture) AND DateTime.ParseExact(str_ServiceDate.ToString.Trim.TrimEnd.TrimStart, "M/d/yyyy", System.Globalization.CultureInfo.InvariantCulture) = DateTime.ParseExact(in_ServiceDate.ToString.Trim, "M/d/yyyy", System.Globalization.CultureInfo.InvariantCulture)

Let mew know if you have azny queries.

Regards

3

After some research found the below changes worked.

CInt(str_RptProviderCode.ToString.Trim.TrimStart.TrimEnd) = CInt(in_ProviderCode.ToString.Trim) AND DateTime.ParseExact(str_ReceiptDate.ToString.Trim.TrimStart.TrimEnd, “%M/%d/yyyy”, System.Globalization.CultureInfo.InvariantCulture) = DateTime.ParseExact(in_ReceiptDate.ToString.Trim, “%M/%d/yyyy”, System.Globalization.CultureInfo.InvariantCulture) AND DateTime.ParseExact(str_ServiceDate.ToString.Trim.TrimEnd.TrimStart, “%M/%d/yyyy”, System.Globalization.CultureInfo.InvariantCulture) = DateTime.ParseExact(in_ServiceDate.ToString.Trim, “%M/%d/yyyy”, System.Globalization.CultureInfo.InvariantCulture)

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.