cancel
Showing results for 
Search instead for 
Did you mean: 

Shape - Group By with Last loses the data type

ahatisTW
NiCd Battery

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)
0 Kudos
3 Replies
ahatisTW
NiCd Battery

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.
0 Kudos
knatarajan
Blue LED

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).
0 Kudos
MagmaMan
NiCd Battery

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