How to find current date value and previous date value?

Help Studio
, ,
1

image
how to find current date oppositive value and previous date oppositive value. Then i need current value - previous value = output value

2

Change the date format to require one like dd MM yyyy hh: mm
And store the current time also in same format in one variable a and
Take time difference function a.subtract(b)
Or time difference(a-b)
Like this you can get the required values
Thanks !
@domsmgtmeet22

3

Hi @domsmgtmeet22

Can you provide the one example? like Input and Output

Regards,
Gowtham. K

4

image
i need find this values

5

You can search by for each row
And apply filter on excel column based on the two values you required
After filtering
What is the step you need to perform
Please explain these part
@domsmgtmeet22

6

Hie @domsmgtmeet22 hope this method work for you
process flow
image
step 1 - your input
A "Build Data Table" dialog box displaying a table with a single column labeled "DateColumn" and several date entries. (Captioned by AI)

step 2- use filter activity
The image shows a Filter Wizard dialog filtering rows in a DataTable based on date conditions, keeping rows where the "DateColumn" equals either yesterday's date or today's date in the format "MM-dd-yyyy". (Captioned by AI)

image
image777×76 6.54 KB

image
image773×61 5.52 KB

The image shows a debugging session in a workflow automation tool, highlighting activities such as filtering a data table and iterating through rows, along with the execution timeline in the output panel. (Captioned by AI)
The image shows a debugging session in a workflow automation tool, highlighting activities such as filtering a data table and iterating through rows, along with the execution timeline in the output panel. (Captioned by AI)1072×509 35 KB

finally your output.
cheers Happy Automation

7

grate … find oppositive value

8

Not Getting your Point ? so any change you want from the previous Logic./

9

i need value…721487 and 721139

10

okay So you only need to change the column name in the for each loop like this
input
The image shows a "Build Data Table" window with columns labeled "DateColumn" containing dates in September 2024 and "Value" containing corresponding numerical strings from 1 to 4. (Captioned by AI)

and inside for each pass column name as seen in the image
so your output look like this

process
This image depicts a workflow in UiPath Studio, showcasing the steps to filter data in a DataTable and iterate through each row of the filtered DataTable to write a specific value to the output. (Captioned by AI)

The image shows a UiPath Studio interface with a project being debugged that involves building, filtering, and iterating over a DataTable. (Captioned by AI)
The image shows a UiPath Studio interface with a project being debugged that involves building, filtering, and iterating over a DataTable. (Captioned by AI)1255×556 36.1 KB

cheers Happy Automation

11

super thank you… for your support

12

@domsmgtmeet22 so Kindly mark this solution and close this query so it help others too.
cheers Happy Automation

13

i have one more doubt
image
how to find month in text write month column

14

@domsmgtmeet22 please close this query as mark this solution and this is your new query so Create this with the new one . so it help other forum member too.
cheers Happy Automation

15

@domsmgtmeet22
Try with the below sequence:
newdate = DateTime.ParseExact(inputDate, “dd-MM-yyyy”, System.Globalization.CultureInfo.InvariantCulture)
monthName = parsedDate.ToString(“MMM”)

Use this inside for each row activity and as an input date pass the value present foreach row.
Thanks ,
Jagravi

16

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