How to compare the date with equal and +/- day

Help
1

How to compare the date with equal and +/- day

For example I have the data (DOS) 2019-07-13, so i want to compare the date for following conditions.

  1. 2019-07-13 (DOS) = 2019-07-13 (Equal Date)
  2. 2019-07-13 (DOS) = 2019-07-12 (One day Minus)
  3. 2019-07-13 (DOS) = 2019-07-14 (One Day Plus)

Can anyone please guide me. Thanks in advance!

2

image
image1010Ɨ437 11.5 KB

1 Like
3

@mukeshkala - Thanks for your inputs but when i tried iā€™m getting below warning message.
Can you please suggest what is the issue.

image
image843Ɨ481 17.8 KB

4

The DOS has to be of type DateTime.

If you are getting it in form of String - Then you will need to Convert.toDateTime(DOS).AddDays(-1).equals(text)

ā€“
Mukesh

5

@mukeshkala - I tried as you suggested but getting the error-
Text variable has data type = String

image
image797Ɨ485 17.5 KB

RemoteException wrapping System.FormatException: String was not recognized as a valid DateTime.
at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.Convert.ToDateTime(String value)
at lambda_method(Closure , ActivityContext )
at Microsoft.VisualBasic.Activities.VisualBasicValue`1.Execute(CodeActivityContext context)

6

Hi @vaibhav2.chavan,

this can do as follows

dte= DateTime.Parse(ā€œ2019-07-13ā€)-DateTime.Parse(ā€œ2019-07-14ā€)
System.TimeSpan
Result : ā€œ-1.00:00:00ā€

to get Days only you need to parse TimeSpan variable as follows
dte.Days
Integer

image

Note : DateTime parse method used to convert date into a same ground

1 Like
7

Please have a look at the variable values - I have kept DOS as String and Its Working for me.

Please Validate the Value in the Text variable in the below screenshot . Can you Writeline the Value of text variable and see what are your getting-

image
image984Ɨ331 10.4 KB

ā€“
Mukesh

8

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