- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
-Jarmo