date format

UROOJRAFFAT

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.

BalazsBarany

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.

UROOJRAFFAT

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

BalazsBarany

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

UROOJRAFFAT

Oh ok thankyoi i will try it

UROOJRAFFAT

Got it thankyou so much its working now