Post reply

Default Value Calculation

  • November 11, 2003 at 4:57 am

    #76077

    How is it possible to perform a calculation in order to determine a default value?

    For Example,

    I have the following columns: start_date1, end_date1, start_date2, end_date2.

    I want the default value on the start_date2 column which must be as follows:

    If start_date1 equals a certain value, start_date2 must be blank, otherwise start_date2 must be the next day after end_date1.

    Any help or suggestions will be greatly appreciated.

  • November 11, 2003 at 9:41 am

    #481602

    This type of manipulation would be better suited for a trigger then a default value. Just use the basic if logic in a trigger to define the values.

    Remember this when a developer tells you it will just be temporary. Temporary = Permanent.

  • November 12, 2003 at 1:22 am

    #481660

    Thanks for the help, Brandon.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply