MS Access97 Date "ddw_23" <ddw_23[ at ]hotmail.com> 13.09.2006 15:04:01 Hi Everyone. I'm trying to change a numeric date into a short date. Can someone assist me PLEASE?? Thanks to all in advance!!!

Re: MS Access97 Date "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 13.09.2006 15:07:59 What's the format of the numeric date? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "ddw_23" <ddw_23[ at ]hotmail.com> wrote in message news:1158159840.925904.31850[ at ]d34g2000cwd.googlegroups.com... [Quoted Text] > Hi Everyone. > I'm trying to change a numeric date into a short date. Can someone > assist me PLEASE?? > Thanks to all in advance!!! >

Re: MS Access97 Date "ddw_23" <ddw_23[ at ]hotmail.com> 13.09.2006 15:37:33 I am trying to convert a numeric date to a short date (ex. 20060424 to 4/24/2006). Thank you! Douglas J. Steele wrote: [Quoted Text] > What's the format of the numeric date? > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "ddw_23" <ddw_23[ at ]hotmail.com> wrote in message > news:1158159840.925904.31850[ at ]d34g2000cwd.googlegroups.com... > > Hi Everyone. > > I'm trying to change a numeric date into a short date. Can someone > > assist me PLEASE?? > > Thanks to all in advance!!! > >

Re: MS Access97 Date "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 13.09.2006 15:40:46 Try: CDate(Format(NumericDate, "0000\-00\-00")) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "ddw_23" <ddw_23[ at ]hotmail.com> wrote in message news:1158161853.717188.102250[ at ]m73g2000cwd.googlegroups.com... [Quoted Text] >I am trying to convert a numeric date to a short date (ex. 20060424 to > 4/24/2006). Thank you! > > > > Douglas J. Steele wrote: >> What's the format of the numeric date? >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "ddw_23" <ddw_23[ at ]hotmail.com> wrote in message >> news:1158159840.925904.31850[ at ]d34g2000cwd.googlegroups.com... >> > Hi Everyone. >> > I'm trying to change a numeric date into a short date. Can someone >> > assist me PLEASE?? >> > Thanks to all in advance!!! >> > >

Re: MS Access97 Date "ddw_23" <ddw_23[ at ]hotmail.com> 14.09.2006 17:00:01 I'm sorry, I didn't make myself clear. I imported text into a database. The date field for all the records are in "text" format based on the table's design view of Access97. In my query or report, I want all the records to show a short date format vs. numbers like 20060424, 20060425, 19990101, etc. I can't change it in my table's design because I loose the data in that field. Thanks. Douglas J. Steele wrote: [Quoted Text] > Try: > > CDate(Format(NumericDate, "0000\-00\-00")) > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no e-mails, please!) > > > "ddw_23" <ddw_23[ at ]hotmail.com> wrote in message > news:1158161853.717188.102250[ at ]m73g2000cwd.googlegroups.com... > >I am trying to convert a numeric date to a short date (ex. 20060424 to > > 4/24/2006). Thank you! > > > > > > > > Douglas J. Steele wrote: > >> What's the format of the numeric date? > >> > >> -- > >> Doug Steele, Microsoft Access MVP > >> http://I.Am/DougSteele > >> (no e-mails, please!) > >> > >> > >> "ddw_23" <ddw_23[ at ]hotmail.com> wrote in message > >> news:1158159840.925904.31850[ at ]d34g2000cwd.googlegroups.com... > >> > Hi Everyone. > >> > I'm trying to change a numeric date into a short date. Can someone > >> > assist me PLEASE?? > >> > Thanks to all in advance!!! > >> > > >

Re: MS Access97 Date "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 14.09.2006 17:29:13 Create a query based on the table, and plug that formula into the query as a computed field. Use the query wherever you would otherwise have used the table. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "ddw_23" <ddw_23[ at ]hotmail.com> wrote in message news:1158253201.534676.46130[ at ]p79g2000cwp.googlegroups.com... [Quoted Text] > I'm sorry, I didn't make myself clear. I imported text into a database. > The date field for all the records are in "text" format based on the > table's design view of Access97. In my query or report, I want all the > records to show a short date format vs. numbers like 20060424, > 20060425, 19990101, etc. I can't change it in my table's design because > I loose the data in that field. Thanks. > > Douglas J. Steele wrote: >> Try: >> >> CDate(Format(NumericDate, "0000\-00\-00")) >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> "ddw_23" <ddw_23[ at ]hotmail.com> wrote in message >> news:1158161853.717188.102250[ at ]m73g2000cwd.googlegroups.com... >> >I am trying to convert a numeric date to a short date (ex. 20060424 to >> > 4/24/2006). Thank you! >> > >> > >> > >> > Douglas J. Steele wrote: >> >> What's the format of the numeric date? >> >> >> >> -- >> >> Doug Steele, Microsoft Access MVP >> >> http://I.Am/DougSteele >> >> (no e-mails, please!) >> >> >> >> >> >> "ddw_23" <ddw_23[ at ]hotmail.com> wrote in message >> >> news:1158159840.925904.31850[ at ]d34g2000cwd.googlegroups.com... >> >> > Hi Everyone. >> >> > I'm trying to change a numeric date into a short date. Can someone >> >> > assist me PLEASE?? >> >> > Thanks to all in advance!!! >> >> > >> > >