Good Afternoon! Everyone I have an excel sheet in that different dates are there. I want to now that date is more than 18 days or not. Please can any one help in this

Help Studio
,
21

Thanks Bro, It is executing but same values are coming which is there in excel sheet.

Thanks

22

@mohammed_zain Use Different Values Inside Message Box such as True or False to Verify if the Date Comparison is Happening Properly

23

DateDiff(DateInterval.Day, “Date1”,“Date2”)
Using this will give you date diff in days.

If the days >18 proceed with your flow else exit the flow

24

Not working bro

Thanks,
Mohd Zain

25

@mohammed_zain What happened ?

26

GM It is not working.

Thanks,
Mohd Zain

27

GM Bro,
Not getting differences of date. Getting same dates which are in excel sheet.

Thanks,
:grinning:

28

@mohammed_zain I thought you just wanted to Compare :sweat_smile:

29

@mohammed_zain Can you please tell us What do you Actually Need, What is the Input and What kind of Operation and What is the Output you need and in Which Form you need, in this way we’ll get better understanding :sweat_smile:

30

yes i want to compare if the date is more than 18 days move to else condition, if it is <18 days move to then condition.

Thanks Bro,
:grinning:

31

@mohammed_zain But what do you want to do in Then Part and what do you want to do in Else part? :sweat_smile:

32

Only i have to check whether the date is >18 or not. It is there in my process from here i will proceed with next sequence or flow.

Thanks,
Zain

33

@mohammed_zain Check this :
BlankProcess11.zip (11.8 KB)

34

Thanks a lot bro,
Its working
:grinning: Happy Automation