Time Format

[rmartinez4]

Hi All,

Is possible to extract the date and time from this format 2022-09-07T16:34:14Z? I don't care for the trailing Z.

Thank You,

[IraWatt]

Hey @rmartinez4,

You can use the date time tool and use a custom format to convert you data to a date time data type:

You can find some good quick videos on how data types work here on the community https://community.alteryx.com/t5/Interactive-Lessons/Understanding-Data-Types/ta-p/73958 or just check the docs your feeling brave https://help.alteryx.com/20221/designer/data-types.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[chuckleswk]

Yes, you can use a formula tool prior to using the date tool to remove the Alpha characters:

Trim(regex_replace([Field1],"[A-Z]"," "))

 

[MarqueeCrew]

@rmartinez4 ,

Please take the time to learn how to create the following formula:

DateTimeParse([Field1],"%Y-%m-%dT%H:%M:%S")

Here are two of my posts about dates:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Marquee-Crew-s-Guide-to-Dates/ta-p/...

https://community.alteryx.com/t5/Engine-Works/MarqueeCrew-s-Guide-to-Avoiding-Date-Frustration/ba-p/...

Cheers,

Mark

Sorry @IraWatt but I discourage the use of that macro.