No problem. So many good ways to simplify code become available with each upgrade to RBase.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: Alastair Burr <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, June 10, 2010 9:22:23 AM Subject: [RBASE-L] - Re: v9.0 INT day/month/year 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. >> >
