How to compare date is <=today

[thima (Himabindu)]

Hi All

I have 2 fields expiration date and effective date on my web page it should be <=today how to compare the dates. Please help me![Date|528x300]

[PrankurJoshi]

Hi @thima

See these

Filter dates less than a particular date

How do i filter dates older than 2017-09-07?

Unable to compare date

Hello, I am trying to compare two dates. One is the date extracted from mail through Outlook which is of the type string and the other one is the System’s date and the type is DateTime. In order to compare these two I am using Compare Date feature which expects variable in Date form. How do I go about. Please suggest some idea. Thanks in advance!! Tamshi

Compare todays date with date of birth

Hi, I need to check date of birth is greater than today or not. For example my date of birth will be in “22/07/1993” we need to compare with today date and check whether it is greater than or less than. Please help me with the logic or code. I tried in this way, getting date, month in different variable and converting them to integer. DOB date<now.tostring(“dd”).tostring and DOB month<=now.tostring(“MM”).tostring. But this will not satisfy my logic. So I need a logic will satisfy my requir…

I am sure you will find a solution from above

Thanks,
Prankur

[niteshn (Nitesh Ningareddi)]

Hi @thima,

You can use compare date activity.

for more info, Please refer below link.

Comparing dates - earlier/later

Hello, I have extracted a column of date(A) from mail, and then extracted another column of date(B) from a database website. I want to check if (A) comes before or after (B). May I know what is the workflow for such comparison? I tried using if (A) < (B) as my boolean, but the results are not what I expected as they gave me an output of 23/07/2017 < 20/06/2017 which is not true as 23/07/2017 comes after. They are in string form and I have no idea how to convert them to DateTime. Please advise. …

Regards,
Nitesh

[PAD]

Hi @thima
In case you are going to use “Compare date” activity, you will need to install Workflow Manager Activities package via Manage Packages.

[PAD]

Alternatively, you can use e.g. ParseExact to convert your original input date in a string format, so you can later compare it with today’s date “date.Now.Date”.

[thima (Himabindu)]

Thank you all for great help my issue is resloved