Distinguish between Date variable and Date field?

Suppose I have a database field called Date. In the header I want to use the System Date variable. If I do this though it will use the database field not the variable. How can you distinguish between the Date system variable and a database field called Date?

Comments

  • edited 10:36PM
    Hello,

    [DATE] = system variable
    [MyTable."DATE"] = field

    Regards
    Pierre
  • edited 10:36PM
    Thanks but that doesn't help me. When I use [DATE] its picking up the database field not the system date variable.

  • edited 10:36PM
    FWIW, never use date, description, name etc. Those are often reserved words for database(ex.sql).

    Is the property UseDefaultDataSetName of the report is set to true. Never tried it though.

Leave a Comment