Results 1 to 3 of 3

Thread: Date Format

  1. #1
    Join Date
    Dec 2003

    Unanswered: Date Format

    I would like to be able to create a field using an existing date field and and extracting the a (2) digit year and a (2) digit week. I have created this and all is well with the exception of the week only produces a (1) digit for the first nine weeks of the year. Ex: "091" would like to see "0901".

    Thanks for all the help in the past.

  2. #2
    Join Date
    May 2005
    The only way I've ever figured out how to do it (unless someone else out there can inform me better), is something like
    format("fldDate","yy") & format(format("fldDate","ww"),"00")
    If you need something like a number, you may need to wrap the whole thing in a Clng or Cdbl or whatever you need.

    Hope that helps!
    Me.Geek = True

  3. #3
    Join Date
    Dec 2003

    Date Format

    That works.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts