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!

  • Congratulations Mike Lewis 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: *

  • Users: toict
  • Order by date
  1. toict

    VPN SETUP

    Hi All, Any news on the above problem? I have run into basically the same thing between a SOHO 6tc and a FB III. On the FB III the tunnel shows up and everything looks good, But cant ping the outside of the SOHO 6 or anything inside. On the SOHO 6 can ping right into the FB III but nothing...
  2. toict

    MUVPN Firebox 1000 - cannot get it to work

    Hi All, Any news on the above problem? I have run into basicallt the same thing between a SOHO 6 and a FB III. On the FB III the tunnel shows up and everything looks good, But cant ping the outside of the SOHO 6 or anything inside. On the SOHO 6 can ping right into the FB III but nothing past...
  3. toict

    Date Conversion Problem

    budbeth, Thank you for your help I was able to modify your suggestion to handle the the extra digits and the results are perfect. NumberVar Year1; StringVar Date1; Date1 :=ToText({Filled.Date}, "0000000"); Year1 :=ToNumber(Date1[1 to 4]); Date (Year1,01,01) + (ToNumber(Date1[5...
  4. toict

    Date Conversion Problem

    For some reason it is still telling me a string is required here. cdate(val(left(?{table.date},4)),1,1)+val(mid({table.date},5,3))
  5. toict

    Date Conversion Problem

    It is definately being stored as 7 digits. the date is the year and day of the year it was ordered 2003335 -> 12/01/2003 2003344 -> 12/10/2003 2003336 -> 12/02/2003 2003336 -> 12/02/2003 2003336 -> 12/02/2003 2003336 -> 12/02/2003 2003337 -> 12/03/2003 Thanks again in advance
  6. toict

    Date Conversion Problem

    This would probably work fine if the the input was a string field however the input is numeric. The field is orderdate for merchandise and I am trying to compare the date to the results of this Date calculation which is when the order was actually filled...
  7. toict

    Date Conversion Problem

    looking for a a way to convert the date format from 7 digits to standard format ie: 2,003,137 to ?/?/2003. Any help would be appreciated. Thank you

Part and Inventory Search

Back
Top