SAP Knowledge Base Article - Public

3438956 - Timestamp related attributes are not showing any result

Symptom

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." 

Environment

SAP Marketing cloud

Reproducing the Issue

  1. Create a custom field with Field type: "Timestamp"
  2. Enable the field as attribute in segmentation
  3. Now use the attribute in segmentation model to filter
  4. You can notice the empty result

Cause

The custom field is created with field type "Timestamp" but in segmentation configuration the semantics is in "Date"

Resolution

While creating custom field with "Timestamp" type then the attribute's semantics should be in "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 achieve it by following steps: Segmentation Configuration -> Segmentation Profile -> Attribute -> Edit the Semantics

See Also

Also check: https://help.sap.com/docs/SAP_MARKETING_CLOUD/ac1eab4c66bc490da7ac2c378c46b0e7/69c9cbd8702d4bc5a987df686069bde2.html#semantic-type

Keywords

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

Product

SAP S/4HANA Cloud all versions

Attachments

Pasted image.png