date format

UROOJRAFFAT
New Altair Community Member
can anyone tell me how can i transform my date , i have a date int his format 20071002T000000 and columb name is polynominal , how can i convert it as a date format properly , i tried nominal to date but its not working , and when ever i am changing columb attribute to date it gives me question mark.? kindly help me into this.
Tagged:
0
Best Answers
-
Hi!
You are on the right track with Nominal to Date. It works with the correct settings.
date type: date or date_time (if you want to keep the time)
date format: yyyyMMdd'T'HHmmss
Regards,
Balázs5 -
You need to enter a custom date format exactly as shown above: "yyyyMMdd'T'HHmmss" (without the quotes)
Do not select one of the predefined formats from the dropdown menu, as they do not match your format.
5
Answers
-
Hi!
You are on the right track with Nominal to Date. It works with the correct settings.
date type: date or date_time (if you want to keep the time)
date format: yyyyMMdd'T'HHmmss
Regards,
Balázs5 -
Hello thanks for your ans i already check this 1 but it shows this error to me
0 -
Hi,
you're not doing what I wrote. The date format setting has to be correct.
Regards,
Balázs1 -
Hello i even choose with this but noy working🤦♀️ thanks for your reply0
-
You need to enter a custom date format exactly as shown above: "yyyyMMdd'T'HHmmss" (without the quotes)
Do not select one of the predefined formats from the dropdown menu, as they do not match your format.
5 -
Oh ok thankyoi i will try it 😊
0 -
Got it thankyou so much its working now🤩0