India Automation User Group

Date Issue in Excel Spreadsheet

  • 1.  Date Issue in Excel Spreadsheet

    Posted Fri January 20, 2023 01:31 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
    ------------------------------