Results 1 to 3 of 3

Thread: month fucntion

  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: month fucntion

    I was hoping this would return the #9, being the current month is oct. How should I use this function to return an integer for the prior month?

    Month(Date())-1


    M~

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    month(date()) should return 10
    ...assuming gregorian calendar & computer clock is ok & blah blah etc

    10-1 is 9, so it ought to work for you.

    what is the context?

    izy

  3. #3
    Join Date
    Oct 2003
    Posts
    311
    It worked, i had the table colm as date/time not number,,, silly me

Posting Permissions

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