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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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...

Part and Inventory Search

Back
Top