Thanks Tom
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Tom Grimshaw > Sent: Wednesday, 13 March 2002 4:55 PM > To: [EMAIL PROTECTED] > Subject: Re: R:BASE TO ORACLE VIA OBDC > > > G'day Victor, > > Check out the R:BASE function: > > (DEXTRACT(datetime)) > > Returns the date portion of a value that has a DATETIME data type. > > In the following example, the value of vdextract is 06/12/93. > > SET VAR vdextract = (DEXTRACT('06/12/93 12:15:30.123')) > > > > At 20:59 12/03/02 +1000, you wrote: > >The problem I have is that the DATETIME function as shown in a > form cannot > >be masked to show just the DATE only. R:BASE laso has a DATETIME > data type. > >nybody have any ideas on how I can just show the date part of > the datetime > >on an R:BASE form. > > Warmest regards, > > > Tom Grimshaw > coy: Just For You Software > tel: 612 9552 3311 > fax: 612 9566 2164 > mobile: 0414 675 903 > > post: PO Box 470 Glebe NSW 2037 Australia > street: 3/66 Wentworth Park Rd Glebe NSW 2037 > > email: [EMAIL PROTECTED] > web: www.just4usoftware.com.au > > This email and any files transmitted with it are confidential to the > intended recipient and may be privileged. If you have received this email > inadvertently or you are not the intended recipient, you may not > disseminate, distribute, copy or in any way rely on it. Further, > you should > notify the sender immediately and delete the email from your computer. > Whilst we have taken precautions to alert us to the presence of computer > viruses, we cannot guarantee that this email and any files > transmitted with > it are free from such viruses. > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
