Extend a Time Value in a DateTime Field

You can use a data modify action to extend the time value in a DateTime field in the destination MDC by a specified count offset.

Before you begin

If you are creating a data modify action to set call out request fields, you must have already created the LDAP call out action that will be referenced in the data modify action. If you are creating a data modify action to set workspace fields, you must have already created the custom workspace that will be referenced in the data modify action.

About this task

Perform this task to configure a data modify action for extending a DateTime value in a destination field by a specified count offset. You can extend DateTime fields in the following destinations:
  • Message — Extends a DateTime field value in a MtxDiamRoMsg, MtxTcapMsg, or a 5G message MDC.
  • Call Out Request — Extends a DateTime field value in the MtxLdapRequestDataExtension MDC, or one of its descendants. Use this destination to set fields in the custom MDC specified in the LDAP callout request selected in this data modify action. The callout request and the data modify action must both be assigned to the same prerating profile.
  • Workspace — Extends a DateTime field value in a custom workspace.
  • Object — Extends a DateTime field value in in a subscription, group, device, user, or an offer object.

Procedure

  1. Create a new data modify action or edit an existing one. To edit an existing data modify action, in Data Modify Actions, click the name of the action you want to edit or click Edit the selected object.
    For information about creating a data modify action, see the discussion about creating a data modify action.
  2. In Start Date/Time, use the date picker to select the date on which the object becomes active in the Pricing database and is first available for use, or enter the date in the format YYYY-MM-DD. Optionally, enter a time for when the object becomes active. The default start date/time is 2000–01–01 00:00:00. If applicable, the range in which the start date/time must fall is listed. For example:
    • Select a date on or before 2021–12–01.
    • Select a date on or after 2020–01–27.
    • Select a date between 2000–01–02 and 2021–10–04.
    Note: If you are creating a new revision of this object, the start date/time must be after the start date/time of the preceding revision and before the start date/time of the next revision. If you are making a copy of this object, the start date/time is not copied. The new object is the first revision, so it has the default start date/time of 2000–01–01 00:00:00.
    By default, data modify actions are active immediately. If you are creating a new revision of a data modify action, you must not change the source type.
  3. In Source, select Time Unit and Count.
    Setting the Data Modify Action source to Time Unit and Count also sets the Destination Action field to Adjust Date Time and disables all other destination action options.
    Note: Choosing a different source for the data modify action resets the destination action to its earlier value.
  4. In Base Date Time, select the base time to use when extending the destination DateTime field.
    • event_time — Use the event time.
    • existing — Use the existing date and time value.
    • min_event_existing — Use the minimum of the event time or the existing data and time value.
    • max_event_existing — Use the maximum of the event time or the existing data and time value.
      Note: If the destination field is empty, the event time is used.
  5. In Count Offset, enter the count value by which to extend the DateTime value in the destination field.
    Note: Do not set the count offset to 0 if base date time is set to existing, because this does not affect the destination DateTime field.
  6. In Units, select the units for the count offset (days, weeks, months, years, hours, minutes, seconds, or milliseconds).
  7. To extend a DateTime field in a message:
    1. In Destination, select Message.
    2. In Destination Container, select the MDC that has the field you want to modify.
    3. In Destination Field, select the field that you want to modify.
  8. To extend a DateTime field in an LDAP callout request:
    1. In Destination, select LDAP Call Out Request.
    2. In Call Out Name, select the name of the LDAP callout action that you want to use.
      The selected call out action determines which type of MDC is used (based on the MtxSubscriber InfoQueryObject.ExtensionName field value) as the destination container for this data modify action.
    3. In Destination Container, select the MDC that has the field you want to modify, where valid containers are the MtxLdapRequestDataExtension MDC or its descendants.
    4. In Destination Field, select the field that you want to modify.
  9. To extend a DateTime field in a workspace:
    1. In Destination, select Workspace.
    2. In Type, select the workspace type.
    3. In Destination Container, select the workspace MDC that has the field you want to modify.
    4. In Destination Field, select the field that you want to modify.
  10. To extend a DateTime field in an object:
    1. In Destination, select Object.
    2. In Destination Container, select the object that has the field you want to modify.
    3. In Destination Field, select the field that you want to modify.
  11. Click Save.