Re: Date Functions

[Mark Brown <markbrown@xxxxxxxxxxxxx>]

Hello Trey,

Friday, September 19, 2003, 7:32:48 AM, you wrote:

TJ> Hello All,
TJ>         I'm trying to export data in ascii format and I need the date to
TJ> be in YYYYMMDD format. TS2000 has a function to export in YYYYDDMM. Does
TJ> anyone know of a simple work around?


 rightstr("      "+numtostr(d,0),6)  this gives you 030919 you could

 untested +"20"+rightstr("      "+numtostr(d,0),6) might give you
 20030919







-- 
Thank You,
Mark Brown 
www.markbrown.com