Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006

    Unanswered: Need formula to place decimal point on number field

    I have a set of numbers that I am concatenating in a formula. The numbers comes over with a decimal point and following zero's. I just want to remove the decimal point and the zero's and have a whole number only. This has to be added to my formula.

    Example: {PHPACCT.AAMMM} & "/" & {PHPACCT.AAMDD} & "/" & {PHPACCT.AAMCY}

  2. #2
    Join Date
    Jun 2006
    From your example it looks like these numbers are being treated as strings, is that the case or are these actually numeric fields?There are different ways of doing this depending on what data type you are dealing with. If these are actually numeric fields and you are trying to format a date (that's what it looks like) you can use the DateSerial function.

    DateSerial(YYYY, MM, DD)

    or with your example:
    Last edited by kledwell; 06-20-06 at 14:44.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts