topic RE: Date Issue in Excel Spreadsheet in Product Forum

Date Issue in Excel Spreadsheet

PalluuM — Thu, 19 Jan 2023 06:21:00 GMT

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.

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

------------------------------
Palluu M
------------------------------

RE: Date Issue in Excel Spreadsheet

GopalBhaire — Thu, 19 Jan 2023 07:04:00 GMT

I guess this is possibly linked to Paste Collection (Fast) is making a mess of date formats | Community Chat (blueprism.com)
Can you confirm whether you are moving data from one excel to another, or just writing in an new excel altogether.

Also, it is worth trying to set the 'Office Authoring language' to something like English India as we use dd/MM/yyyy format.

------------------------------
Gopal Bhaire
------------------------------

RE: Date Issue in Excel Spreadsheet

PalluuM — Thu, 19 Jan 2023 07:57:00 GMT

Hi Gopal,

Each time the collection writes to new excel sheet.
Its a client machine and we only have English (UK) and English (US) on Language Proofings .

------------------------------
Palluu M
------------------------------

RE: Date Issue in Excel Spreadsheet

PalluuM — Thu, 19 Jan 2023 08:03:00 GMT

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

------------------------------
Palluu M
------------------------------

RE: Date Issue in Excel Spreadsheet

GopalBhaire — Thu, 19 Jan 2023 09:25:00 GMT

try it with the UK one as default maybe?

------------------------------
Gopal Bhaire
------------------------------

RE: Date Issue in Excel Spreadsheet

PalluuM — Thu, 19 Jan 2023 10:26:00 GMT

yes its UK by default . However the system time is "dd/MM/yyyy". As you see on my screenshots the dates change to "MM/dd/yyyy" randomly .

------------------------------
Palluu M
------------------------------

RE: Date Issue in Excel Spreadsheet

plnarayana777 — Thu, 19 Jan 2023 10:52:00 GMT

Assuming you have issue while writing to excel if possible try to append single quote " ' " as prefix to the date Ex : '01/11/2022 so it will write as text to excel.

------------------------------
Lakshmi Narayana
------------------------------