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

Can you post a sample file showing this?

I am not sure how to do that,

Make a copy of your file, delete everything that's irrelevant to the problem (along with any sensitive data, of course), zip the file and attach it to your post.

... when making a post you can click the "Manage Files" link. A popup window will open allowing you to browse and select file(s) off your hard drive, then click "Add". When finished click "Finished" and the window will close so you can continue making your post.

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

30 days past which date? The invoice date? The date next payment is due?

You need to specify the field in the Payment Record as Type = Date, then click Options, then click Calculated value, then click Specify ...

{name of existing date field} + 30

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.

Alright. Do you have a relationship from Invoices to Payments by InvoiceID?

If so, in Invoices define a calc, result Date,

NextPaymentDue = (Inv_Payment::Date_Payment) + 30

Sort the relationship btw Invoices and Payments by Date_Payment desc so that FM sees the last payment.

This will calc the next payment 30 days from the most recent last payment. 30 days is not a month, btw.

And what is the date of the first payment? And what happens if one creates two payments without committing in-between? And why is this necessary at all - are new payments created endlessly, or is there a fixed number of them?

Well, yes, you would need to consider Balance Due, and if there are no payments, you could calc NextPayment equal to Invoice Date +30. Two payments without commiting, that could be handled with a script. Aren't you the pessimist?

Who knows why this is necessary? A statement?

My point is that (assuming we are talking about a fixed number of payments) this SHOULD be handled by a script - ALL of it.

Aren't you the pessimist?

I don't know - but I am not optimistic about your date calculation working properly...

Oh, that hurt. Well, again we're trying to provide answers by guessing at the big picture. Anytime I try to probe for "where's this going," I seem to get shot down. I need to meet up with Mr. Vodka.

Yep, Dr. Vodka has all the shots you need.

Smooth Michael, very very smooth.

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

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

And what do you do with the other 5 days of the year? If you party, I'll move there ROFLMAO!

Edited March 11, 200916 yr by Guest

Oh Yeh, we party an extra 5 days each year. Well, 2 days of party and 3 days to recover.

I need to meet up with Mr. Vodka.

Darn got a shout out and I wasn't even online to respond at the time... lol. Next time I bring the booze.

Oh, I assumed you were bringing the booze the first time. Nice to see you around again.