How to convert month text format?

Help Studio
, ,
1

image
how to find month in text format in month column kindly share your knowledge

2

@domsmgtmeet22,

Tried this approach?

3

its not working sir…

4

Would you specify what’s not working or error. We can make it work.

5

The image displays a Visual Basic for Applications (VBA) script in Excel, which sets the number format of column B on Sheet1 to display months in full name format, encapsulated within an "Invoke VBA" activity. (Captioned by AI)
The image displays a Visual Basic for Applications (VBA) script in Excel, which sets the number format of column B on Sheet1 to display months in full name format, encapsulated within an "Invoke VBA" activity. (Captioned by AI)917×220 9.48 KB

showing this error

6

@domsmgtmeet22,

You need to save the code into a text file in your project folder then pass that file name here.

A "Invoke VBA" command interface is shown with a tooltip explaining that the VBA source code file path must be quoted. (Captioned by AI)
A "Invoke VBA" command interface is shown with a tooltip explaining that the VBA source code file path must be quoted. (Captioned by AI)706×230 10.3 KB

and in place of "Main" pass "Macro1"

7

Hie @domsmgtmeet22 hope this help you
your process
The image depicts a workflow from a data processing application with steps to build a data table, iterate through its rows, assign values, convert date formats, and log messages. (Captioned by AI)

your input

The image shows a data table being built with a list of string values representing dates in a software interface, with the output assigned to a variable named "dtdata." (Captioned by AI)
The image shows a data table being built with a list of string values representing dates in a software interface, with the output assigned to a variable named "dtdata." (Captioned by AI)938×430 21 KB

inside for each row use this
save your row value in a variable
image

your convert logic

The image shows the UiPath Expression Editor window with an assignment statement that parses a date string in "dd-MM-yyyy" format and converts it to the full month name using the InvariantCulture. (Captioned by AI)
The image shows the UiPath Expression Editor window with an assignment statement that parses a date string in "dd-MM-yyyy" format and converts it to the full month name using the InvariantCulture. (Captioned by AI)869×287 18.9 KB

finally your output
The image displays the output log of a debugging session, showing the start and end of the "Standard_Cost_Approval_Data" execution process along with a list of months from January to June. (Captioned by AI)

Note: this two variable that i create inside the for each is of string type
also change your date format as per your logic

cheers Happy Automation

8

The image shows an "Invoke VBA" activity in an automation workflow with a highlighted file path leading to an Excel file located on a network using specific user credentials. (Captioned by AI)
The image shows an "Invoke VBA" activity in an automation workflow with a highlighted file path leading to an Excel file located on a network using specific user credentials. (Captioned by AI)821×198 9.85 KB

kindly assist me

9

The output window of a debugging tool shows an error message "Assign: String '' was not recognized as a valid DateTime" while an assign activity in the workflow is highlighted. (Captioned by AI)
The output window of a debugging tool shows an error message "Assign: String '' was not recognized as a valid DateTime" while an assign activity in the workflow is highlighted. (Captioned by AI)1724×597 42 KB

10

Hi @domsmgtmeet22

Can you try below

This image shows a workflow process in UiPath Studio that includes building a data table, invoking code to add a month column, outputting the data table as text, and displaying the result in a message box. (Captioned by AI)
This image shows a workflow process in UiPath Studio that includes building a data table, invoking code to add a month column, outputting the data table as text, and displaying the result in a message box. (Captioned by AI)786×615 25 KB

For Each row As DataRow In dt.Rows
    row("Month") = DateTime.ParseExact(row("PO Date").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("MMMM")
Next

The image shows a dialogue box titled "Invoked code arguments" with a single argument "dt" of type DataTable and direction In/Out, assigned the value "DT". (Captioned by AI)
The image shows a dialogue box titled "Invoked code arguments" with a single argument "dt" of type DataTable and direction In/Out, assigned the value "DT". (Captioned by AI)886×259 9.05 KB

Regards,

11

@domsmgtmeet22

Download this code and configure your activity as per it.

https://www.uipath.com/hubfs/Activities/InvokeVBA%20Example.zip

12

The image shows a debugging window with an error message indicating an exception in an "Invoke Code" activity within a programming environment. (Captioned by AI)
The image shows a debugging window with an error message indicating an exception in an "Invoke Code" activity within a programming environment. (Captioned by AI)1515×491 28.5 KB

13

Can you Show me the Output Date Format of po_date variable like use log message for the po_date variable and show the extract data i need to view the format

14

show an log message but its not write datatable

15

after the po_date use log message and comment out the 2 assign variable and run the process then it will show the output

16

i see log message output its correct. but its not write datatable

17

Actually i want to see your Output format because when i try it will give me the data like this

but i have to convert it to this first

This image shows the Expression Editor in UiPath where a log message is being constructed to include a split value from the "CurrentRow" variable. (Captioned by AI)
This image shows the Expression Editor in UiPath where a log message is being constructed to include a split value from the "CurrentRow" variable. (Captioned by AI)866×309 16.5 KB

The image shows the Expression Editor in UiPath with a 'Log Message' activity, where the log message is set to combine the text "Without Split Value -" with the value from the "Number" column in the current row, converted to a string. (Captioned by AI)
The image shows the Expression Editor in UiPath with a 'Log Message' activity, where the log message is set to combine the text "Without Split Value -" with the value from the "Number" column in the current row, converted to a string. (Captioned by AI)691×319 15 KB

Actual data is coming in this format from excel
The image shows a list of execution logs for "Standard_Cost_Approval_Data" with entries for "With Split Value" and "Without Split Value" spanning from 01/05/2024 to 07/05/2024. (Captioned by AI)
you can see the difference
try this method

Summary: i think while bot read the data from the excel it also take the hour:minute:second also from so first we have to split so we can only get the time and extract the month
cheers

18

1.First Read The Sheet, you will get output as data Table.
2. Now use For each row in datatable Activity and pass the Dt .
3. Now take one assign , In that create one string type variable
For eg: str_date = currentrow(“PO Date”).tostring.Split(" "c)(0)
4. Now create another string type varible
For Eg : str_Month = DateTime.ParseExact(str_date,“MM/dd/yyyy”,Nothing).tostring(“MMMM”)
5. Now take one assign
currentrow(“Month”)=str_Month

This will Update Month Column
Please Refer Below Screenshot:

The image shows a UiPath workflow for iterating through each row in a data table and assigning date and month values to variables, with the immediate panel displaying the data and the output panel indicating debugging information. (Captioned by AI)
The image shows a UiPath workflow for iterating through each row in a data table and assigning date and month values to variables, with the immediate panel displaying the data and the output panel indicating debugging information. (Captioned by AI)1888×778 64.5 KB

If you like my solution please mark it as solution. Thanks :blush:

19

@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