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

[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.