eom | Configurable ODE/PDE solver

I have such enum/range:

period: 'UTD' | 'EOM' | 'ETM'

I want to iterate through all options in select:

I am seeking to find optimal control (aoa and bank angle) to maximize cross range for a shuttle type reentry vehicle using Gekko. Below is my code currently and I am getting a "Solution not found" with "EXIT: Maximum Number of Iterations Exceeded". The simulation assumes a point mass with a non-rotating earth frame. The EOMS are 6 coupled, non-linear ODEs. I have tried using different solvers, implementing/removing state and control constraints, increasing maximum number of iterations, etc. I am not confident with my setup and implementation of the problem in Gekko and am hoping for some feedback on what I can try next. I have tried to follow the setup and layouts in APMonitor's Example 11. Optimal Control with Integral Objective, Inverted Pendulum Optimal Control, and Example 13. Optimal Control: Minimize Final Time. Solutions I'm seeking are below.

Any help is very much appreciated!

I need to create end-of-month dates as an array and them loop through them to calculate each skuid quantity at the end of the month (also need to union each eom information in one table, but it will be another issue), starting from 2021-01-31. Tried this query (create array of eom --> then unnest them in the for loop --> use each date to filter the existing dataset), but it does not work, where could be problem?

I am totally new in macro's so I would like to know where did I make mistakes in my code.

I just want a simple IF - AND based on 2 different columns and the result should be in the third column

My code is:

It's probably easier for me to explain this using sample tables.

So I have two tables, (not sure how to convert this into formatted text)

1. Product EOM Table

1. Transaction Table

And the result I want to get is to find out the latest transaction date before each EOM date, like below.

I am trying to find the last day of the month and compare it to today's date
I do NOT want the integer number I would like the result in this format "MM-dd-yyyy"
Date Picker will not work for this project
Here is the code I using but the process seems overly complicated concocting strings
Side note when today is after the 4th Tue I write True and the Last Day of the month to a DB
when today is after the last day of the month and the bool is now True I write the new last day of the new month and false to the DB

As the pictures below shows, in debug mode, we can see

I have a dataframe that I'm converting to JSON but I'm having a hard time naming the object. The code I have:

I have two dataframe which I want to join normally i do inner_join which gives only the one which are present in both dataframe and rest and not shown in my output.

How to do innerjoin and keep all the rows and assign label

First dataframe