Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
MAKEDATE(YourYear + 2000, YourMonth) should deliver the 1st of each month.
HTH
Peter
MAKEDATE(YourYear + 2000, YourMonth) should deliver the 1st of each month.
HTH
Peter
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
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