I am trying to populate a custom field with a variable depending on the datetime in a field we have synced from Salesforce. Depending on the date of the Salesforce field, I want the custom field to populate with a specific string, these are different depending on the week.
For some reason this flow step is not working as I would suspect and I think it is due to the datetime field not reading as between these dates. The flow step I have set up is as follows:
The choices follow on as this so that each lead within each week increment gets a new value. The Segmentation Datetime field also reverts to having "12:00" at the end which I don't want (as I just want leads within these 2 dates inclusive) - I am not sure if this is the cause of my problems.
During testing I could not get the flow to work with separate dates and all leads reverted to choice 1. Does anyone have any ideas?