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