date difference

[ebco]

select * from mytable where date = '20040402'

what if i want the record for one from the given date how to get the next months date

i.e. 20040502

[fractalvibes]

Use the DateAdd function

fv

[glenngv]

The date field must be of datetime type or if varchar, it must be of recognizable date format (2004/04/02 and not 20040402) so that you can CAST or CONVERT it to datetime.

[ebco]

thanks


it is working with DateAdd function