I have a button that generate excel with date added but there's a problem my logic to the date format is correct "yyyy/MM/dd" but when it comes to generating, the date and month only move. is this an error? or are there any solution to this error?
my format date:
the output when i generate it to excel:
Hi, try set the control panel or keep the cell in text data structure by adding single quote in front "'":
Yes, even though that i change the format date the excel will still follow their format so that's that. and im trying to use the "" so that excel will not read it as a date
Hi budang
You can do it like this
Hi @budang haba ,where are you doing the above date formatting?Is it during record list to Excel functionality?Regards,
yes
The above Excel output date format is just the default format of MS Excel, if there is a requirement for the specific format then you will need to create an Excel template with the column date formatted as per your requirement and then add it to your resource folder.and with the help of advanced excel forge component, you will be able to achieve your result.Check this linkhttps://www.outsystems.com/forums/discussion/89122/excel-resource-calculate/Let me know if you have more queries.Regards,
Hi,
Hope your using format datetime function while uploading data to your Excel like below SS
i dont use any forge here where is this ?
Not forge component before appending Your record list to excel use format datetime function to the field where you want "yyyy/mm/dd " format or else you can use "Advance xl" forge component so that you can alter how ever you want.
i actually tried that but it didnt work
I think its an excel behavior. I hope you are referring to the date which was highlighted in the below image. If so, you need to change cell format in excel. If you want to customize the excel, you can use Advanced excel forge component.
https://www.outsystems.com/forge/component-overview/355/advanced-excel
Regards,
Wasimkhan S
i dont use advance excel
you can change format as per your requirement.
If you have any doubt feel free to ask.
Regard
Rohit
It Actually worked thanks!