Hi I have a column which contains date and I need to change its format from general to date in excel by using advanced as I am writing excel with values and downloading it. I have date entity which has values in date data type and I am giving this values as cell values in cell_write action of advanced excel. In cell_write I have given the cell type as "datetime" and in NumberFormat I have tried multiple variations of date formats like"dd-mm-yyyy", "yyyy-mm-dd" but nothing seems to work.
Here's a screenshot of the problem as you can see the Number Format is causing the problem and I am getting custom as the format in excel instead of date.
Thanks for all the replies just resolved it the Number Format for date should be "M/d/yyyy"
Hello Moin
I saw similar issue in forum you can check once
I have added link for your refrence.
https://www.outsystems.com/forums/discussion/48527/advanced-excel-setting-the-date-format-in-outputted-excel/
Thanks
Mohd Rizwan
Actually they have not mentioned the what to be added in the NumberFormat for getting the date as the format in excel
Hi Moin
Using Google, I found this: https://support.microsoft.com/en-us/office/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e
Hope this helps.
Hanno
The formatting part is not mentioned there please help I am in urgent need
I specifically want to know what should be added in the NumberFormat Input as shown in the Image
Hi
You need to change CellType into "Date" first .
and you are directly passing the date type data to excel but excel support text format so you need to convert it in text and pass it.
and see the format of you excel sheet also some time we fetch correct but due to format we get like you are getting #####.
do this and let me know !
can you share the oml file