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