Compare excel date to System date

Help
#1

Hello All,

I want to compare my excel date and system date whether is match or mismatch.

for example my excel date is in “B5” cell how I can compare with the system date

1 Like
#2

@Abudhahir 1.Use read cell activity and pass cell value it will store the result assume V1

  1. Use if condition and check with today’s date
#3

Hi @Abudhahir

Use datetime.now to check the value of excel date and the system date.

cheers

Happy learning

2 Likes
#4

Hi @Abudhahir

Create a CreatedDate as Datetime variable
CreatedDate=row(“ColumnName”).ToString

If(CreatedDate.ToString.equals(System.DateTime.Today.ToString(“MM/dd/yyyy”))

Thanks
Ashwin S