convert numeric value to year (DATE field)

Well that's what 2016 as a numeric date value ought to convert to... assuming it doesn't really matter what date in a given year you need it to be, make a custom column saying "01/01/" and then merge that with your year column. It should then give you a format that you can convert to date type.

HI, Bbrown44

After my test, the category field doesn't need a date variable.

for example:

I have three type of category: text, number, date

then I separate drag them into the category field of bar chart with variance.

They work well

Also If you want to convert numeric value to date.

you do it like this:

change the column type into Text first.

for example

then convert to date

Note:

When converting text to date and this window appears

Click Add new step

Otherwise it will not success.

Best Regards,
Lin