topic Re: Data Load Editor - Date fields not tagged with $date in App Development

Data Load Editor - Date fields not tagged with $date

DavMer — Mon, 07 Jun 2021 11:11:08 GMT

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?

Re: Data Load Editor - Date fields not tagged with $date

Jayavignesh — Mon, 07 Jun 2021 10:57:18 GMT

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

Re: Data Load Editor - Date fields not tagged with $date

DavMer — Mon, 07 Jun 2021 11:09:25 GMT

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.

Re: Data Load Editor - Date fields not tagged with $date

Jayavignesh — Mon, 07 Jun 2021 11:39:05 GMT

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

Re: Data Load Editor - Date fields not tagged with $date

DavMer — Mon, 07 Jun 2021 12:10:09 GMT

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

Re: Data Load Editor - Date fields not tagged with $date

DavMer — Mon, 07 Jun 2021 14:12:27 GMT

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;