Hi.
I am trying to create an interactive report in APEX . One of the column in my database table has date entry of type numbers with blank spaces in between like 1046 1000 2100.
I tried varchar(2) and numeric/number and a few others and each time I insert data into this column using the APEX form I get the following error. Can you please suggest what data type is most appropriate for this requirement or if there is some setting in the apex application itself that needs to change to allow for this type of data. When I enter the same numbers without blank spaces it works fine 104610002100 . Thanks
1 error has occurred