Robotic Process Automation (RPA)

 View Only
Expand all | Collapse all

Date Issue in Excel Spreadsheet

  • 1.  Date Issue in Excel Spreadsheet

    Posted Thu January 19, 2023 10:07 AM
    Dear All,

    I have been facing issues with Date after writing the collection to excel .
    1) Date as a Text in Collection.
    2) Date as Date  in collection.

    1)Date as a Text in Collection:
     when I use Date as a Text in collection and after writing it to Excel , the Date format changes from "dd/MM/yyyy" to "MM/dd/yyyy" .  This change occurs randomly each time and not with all the dates . The current BP version I am using is 6.10.
    When Writing the Date as a Text to Collection , The occurs as below , Instead of 01/11/2022 it changes to 11/01/2022 . Any help is much appreciated
    Date
     
    18/10/2022
    19/10/2022
    20/10/2022
    21/10/2022
    22/10/2022
    23/10/2022
    24/10/2022
    25/10/2022
    26/10/2022
    27/10/2022
    28/10/2022
    29/10/2022
    30/10/2022
    31/10/2022
    11/01/2022
    11/02/2022
    11/03/2022
    11/04/2022
    11/05/2022
    11/06/2022
    11/07/2022
    11/08/2022
    11/09/2022
    11/10/2022
    11/11/2022
    11/12/2022


    Note: The Excel settings are checked from Format cell and there is no issues on it.

    2) Date as a Date in collection:
    In this the Date on the"EmptyField"become 12:00:00 value and I am not sure how to get this value deleted . This occurs after writing the collection to excel . This occurs on any empty field of the Date Header.
    Date
    12:00:00   
    29/07/2022
    30/07/2022
    31/07/2022
    01/08/2022
    02/08/2022
    03/08/2022
    04/08/2022
    05/08/2022
    06/08/2022
    07/08/2022
    08/08/2022
    09/08/2022
    10/08/2022
    11/08/2022
    12/08/2022
    13/08/2022
    14/08/2022
    15/08/2022
    16/08/2022
    17/08/2022
    18/08/2022


    ------------------------------
    AARTHY ANNADURAI
    ------------------------------


  • 2.  RE: Date Issue in Excel Spreadsheet

    Posted Mon January 23, 2023 09:23 AM
    consider your data is correct, does it?
    Consider input correct data to correct formatted collums in excel, does it?
    Excel is not belonged to IBm RPA, so we have make sure data transformation is natural as human input.

    --
    Thanks and Regards
    Nguyễn Kim Trọng



    Original Message