How to create a Long value Customfield in Jira?

[Ahmad Awadallah]

Hi,

I create a Number customfield and trying to store a Long value to it.  When this occurs I get the following:

org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][parentkey,null][customfield,16801][issue,140435][id,9209080][numbervalue,1.5146784E12] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Out of range value for column 'NUMBERVALUE' at row 1))

I can't find a customfield that will store Long value.  I need to store this Long date and then was going to run a calcuated field to take this Long number and convert it to a date.  

Any ideas?

Thank you.

[M Amine]

I would recommend using a text field and use scriptrunner behaviour in order to check typed value