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

@domsmgtmeet22 , Tried this approach? [image] How to convert month in text format? Studio slight_smile domsmgtmeet22, Ok in this case you only have VBA option. Use Invoke VBA Activity. Put this code in a text file and change the Sheet name and Column as per your data. …

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

<a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/4/1/b/41ba76feba1798f1e146648761970a784aa43fe4.png" data-download-href="/uploads/short-url/9nsx95ACBhiyxr0COBoupYZ2dlq.png?dl=1" title="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)" rel="noopener nofollow ugc">[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)] showing this error

@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)] and in place of "Main" pass "Macro1"

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 <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/1/7/8/1788d5c354ed4d05244186c7b083e9601afa4aad.png" data-download-href="/uploads/short-url/3mc9gBveC5s2GbuuZZ2c3XkwpvD.png?dl=1" title="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 be…

<a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/7/5/b/75b910e492584800d87333db40b9c6c0a6651948.png" data-download-href="/uploads/short-url/gNqmHg7cEg9mGA6sKNYTDLETszS.png?dl=1" title="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)" rel="noopener nofollow ugc">[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)] kindly assist me

<a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/0/9/5/09502aa314b001d9de1976990c3017bbe5364543.png" data-download-href="/uploads/short-url/1ko3iNsw41RezHT1JazcIseu6jx.png?dl=1" title="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)" rel="noopener nofollow ugc">[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)]

Hi @domsmgtmeet22 Can you try below <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/e/2/c/e2ca0fdc2a056fbf0a5d5b41c21a0f1953050ae8.png" data-download-href="/uploads/short-url/wmgP5GtCq5TzhArRyPv9RLvwRWU.png?dl=1" title="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)] For Each row As DataRow In dt.Rows…

@domsmgtmeet22 Download this code and configure your activity as per it. https://www.uipath.com/hubfs/Activities/InvokeVBA%20Example.zip

How to convert month text format?

Help Studio

ashokkarale (Ashok Karale) September 12, 2024, 9:48am 2

@domsmgtmeet22,

Tried this approach?

Topic		Replies	Views
How to convert month in text format? Studio studio , question , workflow_diff	10	95	September 12, 2024
How to convert month to text? Studio studio , question , workflow_diff	10	223	August 26, 2024
How to change month to number Studio uiautomation , activities , studio , date , datetime	45	1326	September 4, 2023
From number to month Studio uiautomation	7	410	February 13, 2023
How to change different date formats in a column Automation Ops question , automation_ops	34	697	October 30, 2023

How to convert month text format?

Related topics