Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
DavMer
Contributor II

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?

1 Solution

Accepted Solutions
DavMer
Contributor II
Author

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;

View solution in original post

5 Replies
Jayavignesh
Contributor III

Please use Date function in your data loading to get fileds in date format.

DavMer
Contributor II
Author

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. 

Jayavignesh
Contributor III

Please use Date () function for all other fields too. e.g. Weekname(Date(SUB_CONNECTED)DATE))

DavMer
Contributor II
Author

Thank you for your suggestion but unfortunately it hasn't made any difference.

DavMer
Contributor II
Author

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;