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
Solved! Go to Solution.
Thanks Josh. The formula worked.
I used the formula as you suggested and the date resulted in leading 0's.
After I used the Select tool to change from integer to V_String, how do I add a leading 0, if applicable?
Thanks.
Oscar
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))
Thanks. The ToString worked as well.