Jim, Karen,
You are absolutely right! I designed it without really thinking fully.
Bernie Lis
----- Original Message -----
From: [EMAIL PROTECTED]
To: RBASE-L Mailing List
Sent: Monday, July 07, 2008 10:26 AM
Subject: [RBASE-L] - Re: LoadFileName.rbl
I wholeheartedly agree with Jim re storing date formats. The other advantage
to using YYYY first is that you can sort and get a correct chronological order.
I had a client where someone else designed a unique column in text format that
included the date format followed by some other data. Because it was text and
they started it with MM, it didn't sort by date order! Changed the computed
column that created this.
Karen
Bernie,
One of the major problems with the way most users code dates into file
names is that they use MMDDYYYY insted consider using YYYYMMDD instead. That
way you could use a wild card such as "200806%" and get all June 2008 files.
set var dformat text = ((FORMAT(.#DATE,'YYYYMMDD'))+'.PDF') -- ON July 6,
2008 gives 20080706.PDF
