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 >
