Thanks, Karen - Jim Bentley gave me a neat solution using format that simplified the whole thing.
Indeed, Jim, I was able to use the same method further on in that RMD as well so removing some more lines of redundant code! Thanks again. Regards, Alastair. From: [email protected] Sent: Thursday, June 10, 2010 2:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: v9.0 INT day/month/year 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.
