# "Split by Data Type.." does not work for Timestamp

**URL:** <https://community.dremio.com/t/split-by-data-type-does-not-work-for-timestamp/2997>\
**Category:** Uncategorized\
**Created:** [March 15, 2019, 3:47pm UTC](https://community.dremio.com/t/split-by-data-type-does-not-work-for-timestamp/2997 "2019-03-15T15:47:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ennpet](https://avatars.discourse-cdn.com/v4/letter/e/a587f6/32.png) [@ennpet](https://community.dremio.com/u/ennpet)\
**Post date:** [March 15, 2019, 3:47pm UTC](https://community.dremio.com/t/split-by-data-type-does-not-work-for-timestamp/2997/1 "2019-03-15T15:47:33Z")

</div>

Hello,

I Imported my dataset from Excel. It contains only one  
column which have in Excel a “Date” data type.  
This column contains 3 values - two valid dates and one invalid.

I want to use “Split by Data Type…” functionality to split the dataset into  
two columns: One column with valid dates of type “Timestamp” and the second on with invalid Dates as “Varchar”.

But I am getting  
“No enum constant com.dremio.common.types.TypeProtos.MinorType.TIMESTAMPMILLI” error.

Data Types:  
SELECT distinct typeof(Bestelldat) FROM s924\_bestelldatum\_2

EXPR$0  
TIMESTAMPMILLI  
VARCHAR

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/5/57fe63a47b419e8ebdfe71b71eafd76a04146435.png)