Alastair: Rather than using #NOW, can you use DEXTRACT(.#NOW)? Karen
> Thank you, Razzak, unfortunately I'm not using a date variable I'm using > a > DATETIME variable which the help indicates is valid: > > Where arg is a value that has either a DATE or DATETIME data type, IDAY > returns the integer day of the month for a particular date. >
