711988_en-US

liliconcom

Creating a New Month column pulling date from an existing column

Good Evening,

I am trying to script to take a date & time from column and create a new column that shows the month and year. the original column is in the format MM/DD/YY hh:mm on a 12 hour clock, and is a numeric continuous column. I would like the new column to be month-year.  Any help would be greatly appreciated.

Data Blending and CleanupData Exploration and VisualizationRe: Creating a New Month column pulling date from an existing column

You need to use the Month() function.

If your column is named Date, the formula would be

Month( :Date );

Re: Creating a New Month column pulling date from an existing column

If you have valid date column, you can right click on the column and create new formula column

This will then create you a new column which you can modify as needed