09-12-2016 02:17 PM - last edited on 09-12-2016 03:32 PM by ChrisHemedinger
I am looking to use an INTNX statement in order to capture the month end date of a value, however I do not have a 'date' field that would normally be entered in the INTNX statement. What I do have is a column listing the numeric value of a month (i.e. 5 if it's May), and a 2nd column listing the numeric value of the year (i.e. 2016).
Any recommendations as to the fastest way to use the '5' and '2016' values to end up with a 05/31/2016 format?
09-12-2016 02:53 PM
Assuming your month and year values are numeric, here's a phrase you could enter wherever INTNX is expecting to see a date:
mdy(month, 1, year)
09-14-2016 05:58 PM