Alpha Video Training
Results 1 to 3 of 3

Thread: Date Operaction

  1. #1
    Member
    Real Name
    Melvin
    Join Date
    Nov 2011
    Posts
    133

    Default Date Operaction

    Hi All

    I'm looking to run a daily operation that will add todays date to any records in a specific table that are >= 30 days old.

    Table: data_incident
    Start Date: crtd_date
    Close Date: clsed_date

    Any idea on how to best build this operation?

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Date Operaction

    That's called an update operation. It is unclear from your description what field needs to have its date changed to today's date but the expression for the update would be

    date()

    and the condition would be

    datefieldname >= date()-30

  3. #3
    Member
    Real Name
    Melvin
    Join Date
    Nov 2011
    Posts
    133

    Default Re: Date Operaction

    That worked like a charm.

    Thanks for your help Stan!

Similar Threads

  1. Report with Daily, Month-to-Date, Year-to-Date Totals
    By Dfred in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 04-19-2012, 03:19 PM
  2. Import Genie Error 1292 - 'Incorrect date value: '10/17/2011' for column 'Date'
    By betty in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 12-27-2011, 12:35 AM
  3. Date Range Fields in Search doesnt respect Grid Properties Date Format or Textbox For
    By aburningflame in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 04-25-2011, 01:38 PM
  4. Replies: 0
    Last Post: 06-22-2006, 05:17 AM
  5. Start date & Week ending date..
    By rae4sp in forum Alpha Five Version 6
    Replies: 2
    Last Post: 09-22-2005, 11:29 AM

Bookmarks

Posting Permissions

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