Jump to content

cul8ter

Members
  • Content Count

    30
  • Joined

  • Last visited

Community Reputation

0 Neutral

About cul8ter

  • Rank
    member
  • Birthday 05/10/1970
  1. Oh Yeh, we party an extra 5 days each year. Well, 2 days of party and 3 days to recover.
  2. I know 30 days is not a month but our laws in nevada pertaining to my business is based on a 360 day year, therefore 30 days is a nevada month. only in vegas!!
  3. the original invoice date is in 1 field, then when a payment record is created i need 30 days from that date to compute automaticaly in the second field, wich would be next payment due date.
  4. is your odbc, and web sharing turned on?
  5. I am trying to get an automatic date to fill a feild when i creat a new record. I have a field that has a certain date in it, let's say 01/01/2009, now when i create a new record for payments i need the second field to automatically change to exactly 30 days,IE;01/30/2009 when i create a new payment record. any ideas??
  6. lets say I have a small number in a field let's say $37.50. I cannot get the number to break down with the decimal point it always comes out as 3750 without the decimal. I have tried number format but cannot figure this one out, does any one have any ideas. Jimmie
  7. i have used this formula it is a general layout but you can change the numbers to work for you. Case ( Field1 ≥ 200 ;Case (Field1 ≤ 1000 ; 17 ; Field1 ≤ 3000 ; 9 ;Field1 ≤ 6000 ; 6 )) James
  8. Mr Vodka is correct I have that set up in my Filemaker 7 when a new record is created it automayically assigns the date it was created and when ever anyone makes a change to that record i have another field wich shows me who changed it what date it was changed and what time it was changed. James
  9. Thanks Jouneyman, i may just need to keep playing around with it until i get i figured out, i think it's more simple than i am making it out to be, i don't know, because of that it is frustrating me.
  10. Hello, I have several fields that i am able to add up for a total, such as principal + intrest = x amount, but i am having a hard time trying to figure out a payoff associated with dates. IE client made payment on 03/07/2008 and has $1,000 in the principal field and lets say a payment of $100 for next months payment due, but lets say they payoff early by a few days, say 28 days i have a field that divides by 30 to get the daily rate but would like to be able to put in a date in a field that would click on a tab and have it show the exact payoff for whatever date they want to payoff. I have t
  11. Calculation within a newly created record. In field 1 i input $1,000. and in field 2 i need for the interest rate of that field to equal a percentage of what is in Field 1 IE; 1,000 times 16% equals 160. or it could be 3,000 in field 1 and 8% of Field 1 or any variations of numbers because there not all the same. any ideas?
  12. Calculation within a newly created record. In field 1 i input $1,000. and in field 2 i need for the interest rate of that field to equal a percentage of what is in Field 1 IE; 1,000 times 16% equals 160. or it could be 3,000 in field 1 and 8% of Field 1 or any variations of numbers because there not all the same. any ideas?
  13. It worked, thank you so much, I have another one for you now that issue is resolved. In field 1 i input $1,000. and in field 3 i need for the interest rate of that field to equal a percentage of what is in Field 1 IE; 1,000 times 16% equals 160. or it could be 3,000 in field 1 and 8% of Field 1 or any variations of numbers because there not all the same. any ideas?
  14. I need to be more clear. I create a new record, and in field 1, i input a number between $200 to $1,000. when i click off the screen i need the number 17 to pop up in the second field.also an amount between $1,001 to $3,000 to input 9 in the second field. and 3,001 through 6,000 in the first field to have 6 pop up in the second field, you get the Idea. this needs to be a calculation but i cannot get my attempts to work, any Ideas? Thank you
×
×
  • Create New...

Important Information

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