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 TouchToneTommy 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: Prisk
  • Content: Threads
  • Order by date
  1. Prisk

    Filtering Dates

    Hi, I'm trying to write a formula that selects dates from a table but does not select any dates starting with - 25/12 26/12 31/12 01/01 I've tried using Day({date_field}) <> 1 and month({date_field}) but this also excludes all dates starting with 1
  2. Prisk

    Selecting record with date nearest todays

    Does anyone out there know how to do this? I have two records for the same company and I want to select the record that has an application date nearest to the current date, is there a formula that I can write to do this?? Thank you
  3. Prisk

    Retrieve character positons from string

    Just wondering if anyone out there can help me with this:- I'm searching a large string for all instances of character 'I' and need to establish not only the number of instances of 'I' but also their position within the string (ie - 1st/2nd etc). I know I can use:- numberVar z := InStr({field...

Part and Inventory Search

Back
Top