How to convert 3 integer columns to date?

Question

Hello.  My data set has 3 columns for Day, Month and Year.  All are in integer.

I want to convert the 3 into a date field.

For example, Day = 3, Month = 6, Year = 2017

Result is a date field: 2017-06-03

Using Select tool, I changed the data type from integer to V_String.  But then don't know how to go further.

I was looking for a concatenate string function but could not find it.

Thanks for your help.

Oscar

JoshKushner · Accepted Answer

You can use the formula:
DateTimeParse([year]+"-"+[month]+"-"+[day],"%Y-%m-%d")

Make sure month and day are all two digits (ex. 01 for January ) and make sure the formula outputs a date format

%Y is used for a 4 digit year (ex.2017)
%y is ised for a 2 digit year (ex. 17)

jdunkerley79 · Accepted Answer

If you want to start with numbers:

ToString([Year])+"-"+ RIGHT("0"+ToString([Month]),2)+"-"+ RIGHT("0"+ToString([Day]),2)

should work

(or if you have the Abacus functions MakeDate(Year, Month, Day))