Calendar Week in Interaction

[former_member549511]

Dear SAP experts,

we need to create custom field in the Interaction which can store the Calendar Week related to the creation date of the Interaction. Is there a standard data type that we can use in our SAP Marketing Cloud system during the field creation? Are there any standard functions that can be used to calculate the value of this new custom field?

Thank you.

Regards.

Andrea

[Kunal_Bansal · Accepted solution]

Hello Andrea,

I am not aware of such a field, you need to use Custom Field here.

Kind Regards,

Kunal Bansal

SAP Marketing Cloud, Consultant

[former_member549511 · Accepted solution]

Thank you very much for your answer!

Ok, we'are going to create a custom field.

Do you think it's possible to create a calculated field from the Interaction Date in order to have the calendar week in format MM.YYYY?

Regards.

Andrea

[Kunal_Bansal · Accepted solution]

I think that should be possible! Give it a try and share your results.

Also, please Mark this question Answered/closed!

[former_member549511 · Accepted solution]

In the end we have created a Custom Field of type CHAR.

Regards.

Andrea