date design issue

Results 1 to 3 of 3

Thread: date design issue

  1. #1
    YLS Guest

    Default date design issue

    hi, i have this problem. when a company is registered, todays date is captured. Now, an email is sent to the company email address every month. <BR>1) how to let my system auto-run and semd the email before 2 days the date due is up?<BR>2) how to code to make sure that every month, an email is sent?

  2. #2
    Steve Cimino Guest

    Default RE: date design issue

    If you&#039re using SQL Server, set up a JOB to run every night or so... in the job execute a query that looks for date + 2... use SQL Mail to send out the notice.

  3. #3
    yls Guest

    Default RE: date design issue

    if not using sql server??<BR><BR>i hope to get a solution that is independent of the database server, i know that i am looking some ways in the line of wsh.. but i need more guidance

Posting Permissions

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