How about

MyStamp = format(FileDateTime("TESTFILE"), 'mm/dd/yy')   ' Returns "2/12/93 
4:35:47 PM".





> but what I am looking is the return date only, not including the time. Any
> suggesstion.
> 
> 
> 
> > -----Original Message-----
> > From:	Donald Brenner [SMTP:dbren01@b...]
> > Sent:	Tuesday, June 26, 2001 10:09 AM
> > To:	professional vb
> > Subject:	[pro_vb] Re: text file
> > 
> > Dim MyStamp
> > ' Assume TESTFILE was last modified on February 12, 1993 at 4:35:47 PM.
> > ' Assume English/U.S. locale settings.
> > MyStamp = FileDateTime("TESTFILE")   ' Returns "2/12/93 4:35:47 PM".
> > 
> > 
> > 
> > Shreekar Joshi wrote:
> > 
> > > Hi
> > >
> > > Check out the Scripting.FileSystem object
> > > Add reference to "Microsoft Scripting Runtime"
> > > You can get a file object returned which gives you all
> > > relevant info of that file.
> > >
> > > Regards
> > > Shreekar Joshi
> > >
> > > --- philip.moh@a... wrote:
> > > > does anyone know how to get the date/time of the
> > > > text file and do the
> > > > comparison in the VB program? I need to know the
> > > > date/time of the file in my
> > > > c:\ drive for some validation purpose...
> > > >
> > > > Thanks.