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,
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 askIra WattTechnical ConsultantWatt@Bulien.com
Yes, you can use a formula tool prior to using the date tool to remove the Alpha characters:
Trim(regex_replace([Field1],"[A-Z]"," "))
@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/156024
https://community.alteryx.com/t5/Engine-Works/MarqueeCrew-s-Guide-to-Avoiding-Date-Frustration/ba-p/181500
Cheers,
Mark
Sorry @IraWatt but I discourage the use of that macro.
