Compare two date variable

Help
1

HI ,
I am not able to get what i am doing wrong.
i want to get exceldate (variable contain date from excel) only if it is less than 3 day from today date.

i get the date from excel , convert it into date time format but stuck at compare date part.
pfa.

  1. if both are the date variable then what will be the condition Main.xaml (42.9 KB)
1 Like
2

Hi,

I am not able to read your .xaml, have you tried this?

Daniel

3

using TryParse() to get Date objects you can use Compare method (date vs Date.now):

Other way could be using TryParse() method to get Date objects, and then Subtract one from Date.Now as a TimeSpan object. Evaluate result

4

Buddy same not able to see the xaml, no worries may i know a sample date format from your excel buddy, we can easily sort this out buddy… @TUSHAR_DIWASE

5

Buddy
its resolved buddy here you go @TUSHAR_DIWASE
datetimeissue.zip (2.9 KB)

Kindly try this and let know buddy whether this works or not

Cheers

1 Like
6

Did that work buddy @TUSHAR_DIWASE

7

thanks for spending time on this.

Sorry but still i am getting the error.test.zip (1.3 MB)

i have used CDate also to convert. I have attached the wf again. please have a look what i am doing wrong.

8

Hey @TUSHAR_DIWASE

Try this:- test.zip (19.4 KB)

Regards…!!
Aksh

1 Like
9

thanks you all for spending time on this issue and providing different feedback

10

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