I want to use a custom property to set a date that a lapsed client email will be sent out. We calculate a lapsed date based on each clients order frequency. That field gets updated into the future every time a client places an order.

I have a segment set to filter anyone who’s LapsedDate = Current Date and a flow set up to trigger the start when someone enters that segment.

My problem is that the date is being entered as a list not a date so it isn’t being picked up by the segment. How do I get the data entered as a date? 

Here is the payload - 

{
  "data": {
    "type": "profile",
    "id": "XXXXXXXXXXXXXX",
    "attributes": {
    },
    "properties": {
      "LapsedDate": "2024-10-03"
    },
    "meta": {
      "patch_properties": {
        "append": {
          "LapsedDate": "2024-10-03"
        }
      }
    }
  }
}

This is what I am getting back

"properties": {
  "MailChimp Rating": 2,
  "MarketSegment": "Corporate Other",
  "LapsedDate": a
    "2024-10-03"
  ]
}