Results 1 to 3 of 3

Thread: Months to Days

  1. #1
    Join Date
    Dec 2002
    Posts
    34

    Unanswered: Months to Days

    Hi all,

    I have a field with the number of months an account is outstanding. I need to convert that to the number of days it's outstanding. Is this possible?

    Thanks,
    SD

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, it is

    select monthsoutstanding * 30 as daysoutstanding
    from yourtable

  3. #3
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820

    Re: Months to Days

    Originally posted by Schoon Dog
    Hi all,

    I have a field with the number of months an account is outstanding. I need to convert that to the number of days it's outstanding. Is this possible?

    Thanks,
    SD
    from a straight number of months you'll never get better than the guy above suggests if you want accuracy then you can use the following where <date> is the field with the date that what ever it was became outstanding ie the due date

    DateDiff("d",<date>,now())

    also

    DateDiff("m",<date>,now())

    will give you the months outstanding (i suggest this as i have know idea how your currently doing it)
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

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