Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

AI Studio

Accepted answers

BalazsBaranyRM

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

Telcontar120

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.

All comments

BalazsBaranyRM

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

UROOJRAFFAT

Hello thanks for your ans i already check this 1 but it shows this error to me

BalazsBaranyRM

Hi,

you're not doing what I wrote. The date format setting has to be correct.

Regards,
Balázs

UROOJRAFFAT

Hello i even choose with this but noy working🤦‍♀️ thanks for your reply

Telcontar120

UROOJRAFFAT

Oh ok thankyoi i will try it 😊

UROOJRAFFAT

Got it thankyou so much its working now🤩