date format
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
Hello thanks for your ans i already check this 1 but it shows this error to me 
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
Hello i even choose with this but noy working🤦♀️ thanks for your reply
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.
Oh ok thankyoi i will try it 😊
Got it thankyou so much its working now🤩
Sort by:
1 - 2 of
21
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
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