Showing results for 
Search instead for 
Did you mean: 

Shape - Group By with Last loses the data type

Shape - Group By with Last loses the data type

It's unclear if this is by design. I have a date column that I am using the Shape - Group By - Last on. The newly generated column becomes a text data type and is no longer a date data type.

Is this by design?

I can workaround it by creating a new Computed Column using the DATEVALUE formula, but seems like an unnecessary extra step.
Labels (1)
3 Replies

That's good to hear it's something that will be fixed/changed in a future release. Just to clarify, if you try to use the newly generated column in a Computed Column using any of the DATE formulas (DATEDIFF etc), the formula does not recognize the value as a date type. I believe it returns an error that it is a number.

Thanks, ahatisTW and MagmaMan. What you are observing is an issue that we will look to resolve. 
You may notice that the individual cell types in the newly generated column are DateTime type as expected, however the column type is incorrect. This should not impact your expected results in the data (the data in the new Col is DateTime as expected).

I think I have seen this too...... Not sure.. But I do vaguely remember losing data type of date fields...