AudienceView Connect
 Product Guides   Knowledge Base   Discussions   Support   Annual Conference   Developer Guide Login   Developer Guides  
 
AudienceView Documentation

Using Relative Dates and Times

Table of Contents | Previous | Next

A relative date and/or time is a way to represent a date or time based on its relation to the current date and time. You can enter a relative date or time whenever you see the duration icon ( ):

  • If the duration icon is located next to the calendar icon ( ), you can enter a relative date.
  • If the duration icon is by itself next to a field, you can enter a relative time (duration).
    calendar-and-duration.jpg
    'Duration' Field 'Relative Date' Field

    For example, if today is September 19, 2012. You can represent tomorrow’s date by entering 09-20-2012 (the absolute date) or +1D (the relative date from today).

Relative dates/times can be entered directly in the field or you can click to select a relative date/time from the duration pop-up:

Hint
There are two different ways that the calendar and duration widgets appear within AudienceView depending on how the date/time fields should be used:
  • : The date/time field should be used to set an absolute date/time (e.g. an on-sale date).
  • : The date/time field should be used to set a relative date/time (e.g. the amount of time Online users have to complete a transaction once the tickets have been selected).
Information
If you enter an invalid relative date range (e.g. +10D to +5D), the values/durations will be swapped and no validation message will appear.

Entering a Relative Date/Time

You can enter a relative date/time directly into the text field. For example: +1D represents tomorrow, -1D represents yesterday, +1Y represents next year, +1M +3D +12h represents one month, three days and 12 hours from now.

Hint
Relative date codes are case sensitive.

Use the following as a guide to entering a relative date.

Code Description
- Represents a date/time in the past.
For example: -1D represents yesterday.
+ Represents a date/time in the future.
For example: +1D represents tomorrow.
= Represents an absolute date/time.
For example: =3D represents the third day of the current month.
Y Year
M Month
D Day
h Hour
m Minutes
s Seconds

Selecting a Relative Date

If you are not sure of the format to enter a relative date or time, you can select the relative date from the Duration pop-up.

To select a relative date or time, complete the following:

  1. Click .
    The Duration dialog box appears.
  2. Select -, {+} or = next to the relative date or time that you want to select.
  3. Enter the amount of time that you want to apply in the corresponding field.
  4. Click 'Apply'.

Example One – Eleven Months in the Future

  • Year: +1
  • Month -1

Example Two – One Year in the Past on the Fifth Day of the Month

  • Year: -1
  • Day: =5