Issue while changing date format in dataset

[Shivprasad99]

For a customer requirement, I need to change the date format in a data set from YYYY-MM-DD to DD-MMM-YYYY. However, I am unable to achieve the same. If I change the format from properties, I get a validation error as shown below. Is there a way to change the date format? Seeking advise from experts here.. thanks in advance

[sourabhpaul]

To change the date format your date values should be in DD-MMM-YYYY (01-Jan-2023). you can do the changes in the backend data or you can change values via wrangling.

[Subhasmit]

Your screenshot is According to your requirement you need DD-MMM-YYYY format . If you look closely at the format, you will see that there are 'MMM' in this format. It means you need three digit for this month format. For this format you need to add "0" in front of the entire column . If you do it this way it will not give any error.

[N1kh1l]

shivmane99

shivmane99During Model/Dataset creation when you select the date column and visit the properties pane of right side, there is a option to select the Date format. I think you do not need to a calculated/converted column as you can just change the format of the existing date column itself.

Hope this helps.

Nikhil

[Shivprasad99]

Hello Nikhil,

I tried changing the date format at model creation but after creating the model, the date format changes. For example: the date format which i selected before creation of model is MM/DD/YYYY and after creating the model it changes to YYYY-MM-DD. Is there a way to keep the format same before and after creation of model. Thank you

Before

After