Jump to content

How do I convert two different types of field into one date field

Ashley Jerue

Recommended Posts

Hello, I have two different types of columns I'd like to combine into a single date. The data currently looks somethinglike:

Month (String): Year (Integer):

Jan 2018

Feb 2019

Mar 2019

Apr 2018

It would be nice if it could come out something like Mon-YYYY or a slight variation.

I'd like to use this field to calculate a balance over the most recent 3 months.

Thanks in advance!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...