Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by NickNiti

  1. NickNiti

    Convert YYYYddd formatted String to Date?

    Great Guys! It works perfect...Sorry about the confusion with STrings and Numbers...I thought that the field was a string.... Your streamlined formula is also very quick.... Much Thanks!
  2. NickNiti

    Convert YYYYddd formatted String to Date?

    Brian....Thanks for the suggestion...But when I try your code I get "A String Is Required Here" numberVar YearNum := Val(Left({rx.FillDate},4)); In this line.... ?
  3. NickNiti

    Convert YYYYddd formatted String to Date?

    I have a faircom C-TREE database which is accessed via ODBC by crystal. The date field for this particular database is YYYYddd where ddd is the day of the YEAR. FOr example: January 1, 2003 ---> 2003001 December 31, 2003 ---> 2003365 I need to convert this string into a crystal date so that I...
See more

Part and Inventory Search

Back
Top