Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
Please use Date function in your data loading to get fileds in date format.
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.
Please use Date () function for all other fields too. e.g. Weekname(Date(SUB_CONNECTED)DATE))
Thank you for your suggestion but unfortunately it hasn't made any difference.
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;