How to make date?

[#1]

Hello all

Im new in QV.

well i have 2 fields like this.

month:

1, 2, 3, 4, 5, 6, 7,...

year:

1, 2, 3, 4, 5, 6, 7, 8...

i have to make them date.

year 1 is mean 2001, 2 = 2002...

how should i do this. please anyone help me.

[prieper · Accepted solution]

MAKEDATE(YourYear + 2000, YourMonth) should deliver the 1st of each month.

HTH
Peter

[#3]

hello peter

well i tried makedate() but its give me 3/1/2001 something like that so thought its not working well.

i figure it out. that date format isnt right. so i used

date(makedate(year+2000,month), 'YYYYMMDD');

now its look like give me correct date format.

sorry for typed newbie question.

Thank you peter

[prieper]

The MAKEDATE should already deliver you a date in the format as in the initial lines of the script under

SET DateFormat = ....

If you wish to change all your date-display as YYYYMMDD, you should be able to write this into the above statement.

HTH
Peter