Results 1 to 3 of 3

Thread: dates

  1. #1
    Join Date
    Jun 2002
    Posts
    72

    Unanswered: dates

    Is there a function of clever way to get the number of of days between the current date and the end of next month without directly entering the next month date, eg

    datediff("d", now(), 'end of next month')

  2. #2
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    t=now()
    datediff("d",t,cdate(year(t) & "-" & month(t)+2 & "-" & "1"))

    this is 'till the beginning of the month after the next (2002-09-01 0:00:00h currently), so infinitisimal little difference from the end of the next month.

  3. #3
    Join Date
    Jun 2002
    Posts
    72
    Thanks.

Posting Permissions

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