Comparing two date values

Help Studio
, ,
1

Hi,

I have a situation of extracting one date value from excel and extracting one date value from Portal using get text… Two date values are showing same in message box but when i compare in if as equal or contain it’s not getting true… find the below image and provide solution…

A screenshot of a "Ticket Data Warehouse" dashboard from Capgemini displaying various ticket management and time tracking details. (Captioned by AI)
A screenshot of a "Ticket Data Warehouse" dashboard from Capgemini displaying various ticket management and time tracking details. (Captioned by AI)499×559 71.5 KB

image
image1832×4096 948 KB

image
image337×244 38.7 KB

image
image1832×4096 998 KB

Regards,
Kishore.

2

Verify if the data types are the same in both.

3

Both are in string type

4

also ensure there are no extra spaces

5

Hi @nanda_kishore

Can you try like below

If DateTime.ParseExact(excelDateValue.Trim(), "dd MMM ddd", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-ddd") = DateTime.ParseExact(portalDateValue.Trim(), "dd MMM ddd", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-ddd")
    ' Matched
Else
    ' Not matched

Regards,

6

Hi
Do this and then compare
DateVariable1=DateTime.Parse("07 Oct Mon").ToString("dd/MMM")

Replace “07 Oct Mon” with the date variable(String type)

Try this!

7

@nanda_kishore,

Comparing two dates in string format not a good practice.

You should be parsing the string format dates into datetime datatype and then compare.

8

hey
it could be related to different type of space chars.
Better approach would be to convert string to date then compare it like below:

Log message = CDate("07 Oct Mon") = CDate("07 Oct Mon")

in above example I used static string, replace it with your desired variables