Hi!

I have an invoice # that is the Date Created and a Company Code, eg: 032305HAG (where 032305 = today's date and HAG is company code for a particular client). To automatically insert this, I created a calculation:

Date Modified &""&ED Contacts::IN Code

However, what appears is some weird #: 732028HAG -- so the company code is going i correctly, but the Date Created is I don't know what - the # does correspond to the date somehow because it is different for a record from yesterday.

Does anyone know why this is doing this and how I should fix it - is there a better calculation?

Also, this is my first posting and I am an advanced basic user who has basically been using the guides that came with the program - what's the best book to buy to start helping me do more advancecd stuff (such as writing script)

THANKS!

Try this instead:

Filter ( GetAsText ( Date Modified ) ; "0123456789" )&ED Contacts::IN Code

The strange number you were getting is the internal numeric version of the date. The GetAsText converts it to text, and then the filter function removes the slashes separating the month day and year.

Thank you so much for replying!

I tried it, but it gives me the message: "Either an operator was ommitted, this function cannot be found, or "(" was not expected here"

Any thoughts?

Sarah

Oops, sorry, I gave you an FM 7 version formula. If you are using version 6 you will need to use this instead:

Substitute(DateToText(Date Modified),"/","")&ED Contacts::IN Code