Hello Everyone, my very first forum post EVER!
I am currently struggling to compare dates (text format) with dates (date format).
- my (text formated) dates are the result of a make scenario
- my (date formatted) dates are already insinde an airtable table named “sessions” which is representing my upcoming courses sessions as a teacher.
Context: I have created a tool that analyses pictures or text entries that are filled with informations of my upcoming educational courses.
The Process: I am filling a form from an airtable interface, i provide pics or text entries of my sessions informations as well as a single select actually asking if i want to directly add the course sessions to my agenda or compare them with already signed sessions –> Make scenario is triggered –> data and prompt are sent to open ai –> open ai provides json with modules names, dates, start time, end time, modality…) –> json parser finds separates modules –> iterator#1 bundles up modules with sessions –> iterator#2 bundles up each sessions in order to create records later.
Starting from json, I eventually get some iterated bundles containing texts with 1.Date , 2.Start Time, 3. End Time, 4. Module Name, etc. Ready to be sent to airtable
a Router is used to filter if i want to directly add the course sessions to my agenda or compare it with already signed sessions, if compare is chosen, the scenario derivates to an airtable “search record” module that should supposedly find date occurences and status occurences.
Questions:
- should I either create a variable using a make module to transform text into date prior to compare or juste make that into the search records formula?
- which formulas to use in the variable creation tool
- which formula to use in the search record formula ??
Please help !! I’ve been turning it all around for 3 days.
you can find in the screenshots shared :
- the form
- the scenario structure
- Outputs
- router filters
