3438956 - Timestamp related attributes are not showing any result

Created a Timestamp related attribute, but while using it in segmentation model, it is not showing any result.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

SAP Marketing cloud

1. Create a custom field with the field type set to “Timestamp"
2. Enable this field as an attribute in segmentation 
3. Use this attribute in segmentation model to apply a filter
4. You will observe that the result set is empty

The custom field is created with the field type “Timestamp.” However, in the segmentation configuration, the semantics are set to “Date.” 

When creating a custom field with the “Timestamp” data type, the attribute semantics should be set to “Date and Time.”

Date and Time

• This semantic type requires an attribute that has the data type SECONDDATE, a numeric type with at least 14 digits, or a character type with at least 14 characters.
• Note that the attribute field in the database must follow the pattern YYYYMMDDhhmmss, unless you are using data type SECONDDATE.
• This type does not support milliseconds. Note that free text search through attributes of semantic type Date and Time is not supported. The search field in the preview is hidden for such attributes.

You can configure this by following these steps: Segmentation Configuration -> Segmentation Profile -> Attribute -> Edit the Semantics

Semantics

Semantics, Timestamp, Attribute, Segmentation configuration, Date. , KBA , CEC-MKT-SEG , Segmentation , Problem