Ashley Jerue Posted October 9, 2019 Share Posted October 9, 2019 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 More sharing options...
Richard Pobi Posted October 9, 2019 Share Posted October 9, 2019 This worked for me. You need two calculated columns. Cal_Column1 [Month] & "-" & [Year] CalColumn2.....Use the Conversion function Date([Cal_Column1]) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now