Creating reports and dashboards | Stimulsoft community forum

Hi ,

Currently in our reports, when adding a date field (in a business object), we have to manually enter the date format next to the field in the Stimulsoft report. This looks like :

{Format("{0:dd MMM yyyy}", IATAStatisticsDataProvider.DepartureDate)}

We do this so when we export the report, the data in the field is recognized as a date field.

Please let me know if there is anyway to have stimulsoft recognize date fields as dates by default without having to add the formatting manually. So in the above example we would only need to have {IATAStatisticsDataProvider.DepartureDate} for it to recognize as a date when exporting.

Thank you in advance.

Hello,

Please try to set the Format property of the Text component.

Also, please clarify which type of the DepartureDate column?

Thank you.

Hi Lech,

Thank you for the response. I am aware of the text format option but I was hoping you could help me without using the stimulsoft designer options, if you can please assist in the c# and .NET aspect when exporting the report. I want it so if I create a date field in a business object (like the above mentioned DepartureDate example) it will have a default date format without having to manually set the formatting in the designer.

Hello,

Unfortunately, there are no options for this. You should set the Format property.

Thank you.

Hi Lech
OK ,Thank you for the response

Hello

Please let us know if you need any additional help.

Thank you.

Lech Kulikowski wrote: ↑Mon Jul 15, 2019 8:43 pm Hello

Please let us know if you need any additional help.

Thank you.

I have this problem, i need the date format dd-mm-yy in the cell when i export the report to excel, but y don't found this format in stimulsoft.

Hello,

Please try to set the Custom format.

Thank you.