Can't create outlook event

:bullseye: What is your goal?

I have Browse.ai set up to successfully scrape a site for new events (a professional organization that adds events periodically) the day comes in but I cannot for the life of me figure out how to get the Date and Time in the correct format I have tried a lot of different ways to accomplish this with no luck.

It comes in as

Cost $15.00
Location IMEG Corp. Greenwood Village
7600 E. Orchard Road
Suite 250 - S
Greenwood Village, CO 80111, CO 80111
UNITED STATES
Time 8:30 AM - 3:30 PM MST
Date Feb 27, 2026
Title ULI Colorado - 2026 UrbanPlan Volunteer Training

anyone have any ideas that work? Thank you!!

:thinking: What is the problem & what have you tried?

I have tried

writing to a google sheet and using an array formula
using chat got module
formula in outlook module for parse

:clipboard: Error messages or input/output bundles

it will successfully go through but schedule it at 12:00am because its not getting the times I need to pull the start time and the end time in DateTime format

Hey there,

Can you show a screenshot, or even better, copy paste the output here so we can see the exact format?

Of it’s just a block of text, you need a text parser first to find the date and the time.