Date text into numeric value

[#1]

Year and month in my data base are two distinct text columns.  Is is anyway I can make transform that into numeric value so I can build a calendar scrip? Any ideas?

[luciancotea]

MakeDate()

[#3]

you can use makedate() function and might possibly need to combine it with num#(). you can look up those functions in the reference manual. if you posted a sample qvw with some data if it would be easier to help you

[#4 · Accepted solution]

Do something like this:

=Num(MakeDate('2013','01',1 ))

Just substitute '2013' with the year column and substitute '01' with your month column.

HTH.

[#5]

Worked beautifully!  Thank you so much!

[#6]

Worked beautifully!  Thank you so much!

[#7]

Worked great!  Thank you so much!