date format
New Altair Community Member
Updated by Jocelyn
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.
Find more posts tagged with
Sort by:
1 - 7 of
71
New Altair Community Member
OP
Hello thanks for your ans i already check this 1 but it shows this error to me 
New Altair Community Member
Hi,
you're not doing what I wrote. The date format setting has to be correct.
Regards,
Balázs
you're not doing what I wrote. The date format setting has to be correct.
Regards,
Balázs
New Altair Community Member
OPHello i even choose with this but noy working🤦♀️ thanks for your reply
New Altair Community Member
Accepted Answer
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.
Do not select one of the predefined formats from the dropdown menu, as they do not match your format.
Sort by:
1 - 2 of
21
New Altair Community Member
Accepted Answer
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ázs
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ázs
New Altair Community Member
Accepted Answer
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.
Do not select one of the predefined formats from the dropdown menu, as they do not match your format.
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ázs