cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

Creating a New Month column pulling date from an existing column

Schnipbt
Level I

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.

2 REPLIES 2
txnelson
Super User


Re: 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 );
Jim
jthi
Super User


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

jthi_0-1703191088342.png

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

jthi_1-1703191112983.png

-Jarmo