Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Date Issue in Excel Spreadsheet

PalluuM
Level 2

‎19-01-23 06:21 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.

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
------------------------------
0 Likes
6 REPLIES 6

GopalBhaire
Level 10

‎19-01-23 07:04 AM

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.

11630.png



------------------------------
Gopal Bhaire
------------------------------
0 Likes

PalluuM
Level 2
In response to GopalBhaire

‎19-01-23 07:57 AM

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
------------------------------
0 Likes

PalluuM
Level 2

‎19-01-23 08:03 AM

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
------------------------------
0 Likes

GopalBhaire
Level 10
In response to PalluuM

‎19-01-23 09:25 AM

try it with the UK one as default maybe?

------------------------------
Gopal Bhaire
------------------------------
0 Likes

PalluuM
Level 2
In response to GopalBhaire

‎19-01-23 10:26 AM

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
------------------------------
0 Likes

LakshmiNarayan3
Level 6
In response to PalluuM

‎19-01-23 10:52 AM

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
------------------------------
0 Likes