
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data Load Editor - Date fields not tagged with $date
I'm trying to use the Date picker object but the only fields that are available in the dropdown box are those that have been tagged with $date (and possibly $timestamp).
I have a number of date fields on my table but for some reason the majority are tagged with only $numeric and $integer but only one of them is also tagged with $timestamp and $date but not sure why as the only difference is that this date is sometimes null.
Does anyone know what I need to do to get these other date fields tagged correctly?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure what the actual issue was but managed to get around it by adding the following line in the Data load script after the Load command:
Tag Fields SUB_CONNECTED_DATE, SUB_DISCONNECTED_DATE, SUB_CONTRACT_START_DATE, SUB_CONTRACT_END_DATE, SUB_RE_SIGN_DATE With $date, $timestamp;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please use Date function in your data loading to get fileds in date format.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have (extract from script now attached) but for some reason the only fields tagged are SUB_DISCONNECTED_DATE, SUB_DISCONNECTED_WEEK, SUB_DISCONNECTED_MONTH, SUB_DISCONNECTED_QUARTER and SUB_DISCONNECTED_YEAR.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please use Date () function for all other fields too. e.g. Weekname(Date(SUB_CONNECTED)DATE))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your suggestion but unfortunately it hasn't made any difference.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure what the actual issue was but managed to get around it by adding the following line in the Data load script after the Load command:
Tag Fields SUB_CONNECTED_DATE, SUB_DISCONNECTED_DATE, SUB_CONTRACT_START_DATE, SUB_CONTRACT_END_DATE, SUB_RE_SIGN_DATE With $date, $timestamp;
