Jump to content


  • Posts

  • Joined

  • Last visited

nycL45's Achievements


Explorer (4/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Thanks, Lee. I read the threads and will look at the files. Leonard
  2. My apologies if this is the wrong forum for this. I did a search of "time tracker" and "timer" without success. Is it possible to create a (start/stop) task time tracker with FM using the computer's clock? It would be ideal for linking to project budget monitoring and billing. Thanks. Leonard
  3. Hi T-Square. Thanks for the welcome. My first post was just a two-minute creation to figure out the equation format and only it is real. But, you are very right about taxes. Egads, I have enough people barking at me. It is unanimous that lookup is the way to go. Thanks. L.
  4. Hmmm. I'm not 100% sure but I better take look at our set up. Thanks for that, BruceR. L.
  5. Thanks for the rapid responses comment and mr_vodka. Comment, your first suggestion worked like a charm. I will try your second one and mr_vodka's, too. Mr_vodka asked, "What is the purpose here of this calc?" An example is when sales tax changes over time. My Search_date would be the date on a proposal which is step one of the money tracking process. The 1, 2, 3 would be the tax rates over time used to calculate costs (purchases, fees, etc.). Edit: I was just staring at the optional solutions and one reason they might not work and why I chose my approach is that normally, tax changes take effect on the first day of the new fiscal year (July 01 here). This year, a change took effect on Aug. 01. So, proposals could have different tax rates within the same calendar year. –L. Edit 2: The date range would then span one or more years and not necessarily begin or end on the same month and day. –L. Thanks. Leonard
  6. Below is a formula using the case function for determining which range the date I specify falls into and it should return 1, 2, 3, or default 0. Currently, it works fine if the date specified is within 2007, i.e., a 1 appears. If I specify a 2008 or 2009 date, it returns the default 0. What am I doing wrong? BTW, 2009 is intentionally left open ended. Thanks for the help. Leonard Case (Search_date ≥ Date( 1 ; 1 ; 2007 ) ; Search_date ≤ Date( 12 ; 31 ; 2007 ) ; "01" ; Search_date ≥ Date( 1 ; 1 ; 2008 ) ; Search_date ≤ Date( 12 ; 31 ; 2008 ) ; "02" ; Search_date ≥ Date( 1 ; 1 ; 2009 ) ; "03" ; 0)
  7. I have searched the manual and here for help with this and strangely, I found nothing. I tried several approaches to format the field within the script and the results. I have a serial number produced with a Loop and want the result if < 10 to be preceded by a zero for sorting purposes. (I believe FM, like spreadsheets, requires a zero before single digits.) The script, i.e., the bcooney/Daniele script, follows below. Thanks, Leonard
  8. Daniele, that worked! The struggle is over . . . and I learned a lot.
  9. I am not doing too well translating 8.5 to 7. Would you translate this line: set variable $counter = $counter +1. I tried using Set field [invoice timecard::record_no.; serialincrement (1;1)] plus others and it is ng. No to this: Just hoping that the recordID that is used in relationships, the key, is not being set thru this routine. And, I will upgrade. Would like to now but it will have to wait. Edit: this script returns 2 in all the records instead of a numerical progression starting with 1.
  10. Thanks bcooney. Your code is for 8.5? I am 7. What am I doing? Looking for a shortcut to the spice islands or it might seem that way to you. : (Kidding.) The number is an entry number for internal purposes. I will try replacing your $counter variables with a global field for FM7. Thanks L.
  11. We have a timesheet input file that sorts chronologically (ascending) and we want a record number for each record (from 1 to 25 records) starting with the first record, automatically entered in +1 increments and ending with the last record. I have created the script below to do this but it does not work. Suggestions welcomed. Thanks. L.
  12. Hi LaRetta and Lee Smith. When I was typing my "Eureka! I found it" post, I guess you were posting your responses. A belated thanks for replying. L.
  13. Cancel this question. I found the option. I thought I had exhausted everything. My bad.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.