(Vapp) building a date method

[Lloyd Butler]

I have a database with a field containing the month as an integer, the day
as an integer and I want to create a date out of it.

I tried:
concat(theMonth,"/",theDay,"/2000")

and set the field 'm_theDate' as a date. Then I tried varchar and still
nothing.

Is it because theMonth and theDay are integer and concat works with strings?

Currently with Vapp 1.9.7.

Thanks

Lloyd Butler
Product and System Development Supervisor
TWN Commercial Services
lbutler at on.pelmorex.com
p: 905.566.9511x286
f: 905.566.9370