Subscribe Bookmark RSS Feed

Tabulate PLatform Question

Steven_Moore

Super User

Joined:

Jun 4, 2014

I would like to use my date column (numeric/continuous/ m/d/y format) in a drop zone for rows.  I have tried changing the date column to character, ordinal, nominal, etc., with no luck.  Any suggestions?  Thank-you!

Steve
1 ACCEPTED SOLUTION

Accepted Solutions
Solution

create a new column using a formula of:

format(YourDateColumn,"m/d/y")

That will give you a character column that you can use as a grouping column.

11157_pastedImage_0.png

Jim
2 REPLIES
Solution

create a new column using a formula of:

format(YourDateColumn,"m/d/y")

That will give you a character column that you can use as a grouping column.

11157_pastedImage_0.png

Jim
Steven_Moore

Super User

Joined:

Jun 4, 2014

I had some problems, so I just selected the "format" under "Date Time" in the formula editor and that seemed to work with just my date column as an argument.  Thanks for the help!

Steve