Masking error or simply misconfigured

[Carl_Vincent]

Hi guys.

I have created a KW for holding "time" like : 10:15:12

My KW is a numeric (up to 9) for optimized search. I put a mask on it like :

But when I use DIP, a time like 08:01:01 become 80:10:1 The import KW value is 080101

How can I import good format ?

Thanks

[Justin_Fandl]

 Hey Carl,

The numeric (9 or 20) data type for a keyword does not allow for a leading zero to be stored in the database table. It will always strip this 0 off of the keyword upon ingestion. The keyword type would need to be alphanumeric for this to function as you'd like it to.

Hope this helps!