- SAP Managed Tags
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
Bluesky
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
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
| User | Count |
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 5 | |
| 3 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.