Convert format date?

Help Activities
, , ,
1

I have variable dateInput = 31/12/2020

I want to check each row from excel (column A) equal dateInput or not.
but CurrentRow format 12/31/2020 00:00:00

How to change format in currentRow?

Guide me about it please.

image
image774×257 6.43 KB

2

Hi @fairymemay

Please try this

DateTime.ParseExact(currentrow(0). tostring,“dd/MM/yyyy”,Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)

3

@prasath_S Now I use below.

DateTime.ParseExact(currentrow(0). tostring,“dd/MM/yyyy”,Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”).Equals(dateInput)

It show error.

image

image
image816×396 11.6 KB

4

Is dateInput a datetime variable

If it is datetime variable

Convert.todatetime(DateTime.ParseExact(currentrow(0). tostring,“dd/MM/yyyy”,Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)).Equals(dateInput)

5

@prasath_S dateInput a string variable.

6

Convert.todatetime(DateTime.ParseExact(currentrow(0). tostring,“dd/MM/yyyy”,Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)).Equals(Convert.todatetime(dateInput))

try this and show what value is stored in dateInput variable

7

@prasath_S same error.

image

8

and what is value of currentrow(0).tostring

10

@prasath_S Value currentrow(0).tostring as below.

image

image
image895×142 4.92 KB

11

Hi @fairymemay
in read range check the preserve format option
image
then use below if condition : CurrentRow(0).ToString.Equals(dateInput)

OR another way is

to use below condition in if activity
DateTime.ParseExact(currentrow(0). tostring,“dd/MM/yyyy HH:mm:ss”,Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”).Equals(dateInput)

Try any way as mentioned above

Regards,
Nived N
Happy Automation