Change Date format in DB

[ishanishah]

Hi folks,

I want to change the date formats of the ingested data from mm/dd/yyyy to dd/mm/yyyy. 

For ex, when I look up the data in the form or schema, I can see the format of date like 06/25/2021.

Is there a way to change the date formats in the backend DB ? We are using SQL DB and have recently upgraded it.

The data is ingested directly from MS dynamics. We have set the regional settings as "Australia" in the deployment wizard.

Any help would be appreciated.

Thanks,

Ishani

[Craig_Thonis · Accepted solution]

Hi Ishani,

I would check out the forum post below if you are looking to change the date/time within a delivery or workflow:

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/date-format-change...

If you are looking to change the date/time fields permanently within the database, you'll need to directly modify the date/time on the database preference side (check out the documentation for your version of SQLServer). Additionally, you may need to alter the data being imported using the formatDate function on the data import.