How to check date is one month previous

Help Activities
, , , , , , , , , ,
1

I have input date as
01/28/2024

From today date it is one month previous how to find this .how to find it in if condition

2

@sruthesanju

You can do this Now.AddMonths(-1).ToString("MM/dd/yyyy").Equals(YourDateString)

If it is date variable then
Now.AddMonths(-1).ToString("MM/dd/yyyy").Equals(YourDateString.ToString("MM/dd/yyyy"))

cheers

3

@sruthesanju

If((DateTime.ParseExact("01/28/2024", "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).AddMonths(1) = DateTime.Today), True, False)

image
image780×245 7.96 KB

4

Hi @sruthesanju

Try this

DateTime.ParseExact("01/28/2024", "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture) = DateTime.Now.AddMonths(-1)

Regards,

5

Hi @sruthesanju

Try this:

If: DateTime.ParseExact("01/28/2024", "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture) = DateTime.Today.AddMonths(-1)
    Then:
        Message Box: "Given date is one month earlier than today."
    Else:
        Message Box: "Given date is not one month earlier than today."

Hope it helps!!

6

I wouldn’t recommend comparing strings here, the .Equals method also works on a DateTime object.

7

Hey @sruthesanju

inputDate = DateTime.ParseExact(inputDateString, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture)

previousMonth As DateTime = DateTime.Today.AddMonths(-1)

if condition:
inputDate.Year = previousMonth.Year AndAlso inputDate.Month = previousMonth.Month

8

@sonnymeyer

yes it does…but gave it because we wanted only date comparision and not time

cheers

9

Assign Activity* : Parse the input date string to a DateTime object.

Dim inputDateString As String = “01/28/2024”
Dim inputDate As DateTime = DateTime.ParseExact(inputDateString, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture)

Assign Activity* : Calculate the date one month before today.

Dim oneMonthBeforeToday As DateTime = DateTime.Today.AddMonths(-1)

If Activity* : Use an If activity to compare the input date with the calculated date.

If (inputDate = oneMonthBeforeToday) Then
’ The input date is exactly one month before today. Place your logic here.
Else
’ The input date is not exactly one month before today. Place your alternate logic here.
End If

Note: In the If activity, compare inputDate and oneMonthBeforeToday . If they are equal, execute the logic for when the input date is exactly one month prior. If not, execute the alternative logic.

10

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