Results 1 to 6 of 6

Thread: Date

Threaded View

  1. Jul 21st, 2005, 01:40 AM #6
    Hojo
    Hojo is offline
    Lively Member Hojo's Avatar
    Join Date
    Jul 2005
    Location
    Brisbane, Australia
    Posts
    119

    Re: Date

    You could put some if statements in you code to check the month and if its only got 28 or 30 days then print the invoices for the next couple of dates

    Eg.

    VB Code:
    1. 'Do processing for today

    2.  
    3.       If Month = "february" then

    4.  
    5.                 If day = 28 then

    6.  
    7.                       'Process invoices for 29,30,31

    8.  
    9.                 End if

    10.      

    11.       Else if Month = "april" then

    12.  
    13.                  If day = 30 then

    14.  
    15.                       'Process invoices for 30,31

    16.  
    17.                 End if

    Etc.. etc... etc...

    then if its the end of the month it will just process the rest of the dates
    You may want to fiddle with feb if you don't want the 29th feb processed on the 28th feb during a leap year, but if you don't care then wolah.

    Hope this sheads some light

    Cheers

    hojo
    Last edited by Hojo; Jul 21st, 2005 at 01:43 AM. Reason: typo
    Despite body and mind, my youth will never die!

    Everytime I learn something new it pushes some old stuff out of my brain!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width