English

How To: Calculate an date item to a null value

Summary

This article shows how to use TABLES to calculate a date item in an INFO file to have a null value.

Procedure

  1. Select the table and records to be updated.

    Code:
    Tables: select sample.dat
    2 Records Selected.

    Tables: list
    Record ID EXPDATE
    1 1 12/31/1999
    2 2 01/01/2000

    Tables: reselect id = 2
    1 Records Selected.

  2. Use the CALCULATE command to set the date item equal to 0.

    Code:
    Tables: calculate expdate = 0

    Tables: aselect
    2 Records Selected.

    Tables: list
    Record ID EXPDATE
    1 1 12/31/1999
    2 2


    Note:
    Calculating the date item to 0 for selected records, in ARCEDIT and ARCPLOT, will also set the value to null.