pastedImage_0.png

Creating a Datetime Field vs a Date Field

Brian_Law_MKTO
Marketo Employee
Marketo Employee

If you need to create a date field to track something a datetime field you will have more token options to populate the field including the following options:

{{system.dateTime}}

{{lead.Created At}}

{{lead.SFDC Created Date}}

{{lead.Acquisition Date}}

The datetime field type also keeps track of seconds. When you export the data change the format of the cell in excel to m/d/yyyy h:mm:ss

Pros and Cons of Using the Date vs Datetime field type:

Date Field

Datetime Field

Field value can’t be populated later using the Created At Date, Acquisition Date or SFDC Created Date tokens since they are Datetime fields.

Field value can be populated using the Created At, Acquisition or SFDC Created Date fields.

Easier to use in Excel then a datetime field.

More difficult to use in Excel then a date field since you may need to convert it to a date field.

Easy to use in an Analytics Lead Performance Report since records can be grouped by Week or Month.

pastedImage_0.png

Also easy to use in an Analytics Lead Performance Report since records can be grouped by Week or Month.

pastedImage_1.png

A little easier to use RCE since the time will not appear for each record.

pastedImage_2.png

A bit more difficult to use in RCE since the time will appear for each record.

pastedImage_3.png

2180
1
1 Comment