Forum Discussion

RenzoM's avatar
RenzoM
Practitioner
9 months ago

Custom Attribute with Date not filtering

Hi everyone! We're having issues to use the filters for dates on a Custom Attribute field. We tested this on segments to get the exact calculation, and we get 0 users. We tried with 'more than', 'le...
Segmentation
  • RenzoM's avatar
    RenzoM
    9 months ago

    Hi DavidO!

    Thanks for your reply! 

    After talking with Braze Technical Support, they found the problem. Looks like the API config wasn't set up correctly. 

    This is the proper code:

    "custom_attribute_with_date": {"$time" : "2024-03-10"}
    After the ' "$time": ' tag, everything goes with the ISO 8601 format, as we said on previous messages.
     
    I hope that this helps anyone else with this issue ðŸ˜Š
DavidO's avatar
DavidO
Strategist II
9 months ago

Hi RenzoM 

It appears 'yyyy-mm-dd' is an acceptable format according to the docs.

API User Attributes Object (braze.com)

Without seeing the field even though it is being detected as time, is it possible it's being stored as a string and not a date/time object? This might explain why it can only be filtered as null or not null but not be filtered by date/time?

😊


  • RenzoM's avatar
    RenzoM
    Practitioner
    9 months ago

    Hi DavidO!

    Thanks for your reply! 

    After talking with Braze Technical Support, they found the problem. Looks like the API config wasn't set up correctly. 

    This is the proper code:

    "custom_attribute_with_date": {"$time" : "2024-03-10"}
    After the ' "$time": ' tag, everything goes with the ISO 8601 format, as we said on previous messages.
     
    I hope that this helps anyone else with this issue ðŸ˜Š
    • DavidO's avatar
      DavidO
      Strategist II
      9 months ago

      Glad you found a solution RenzoM ðŸ˜Š