I am trying to create a If Then Statement that would return a value from a Table Lookup if another Attribute equals a value but can't seem to figure out how to do that.
For example: If my 'Site Status' = "Active" then I want it to return the current date in the DataEndDate attribute. If the 'Site Status' = "Inactive" I would like it to select the DataEndDate field in a table. Is this possible? 'Site Status' is set to lookup the value in the same table.
Here is an example of my imported table that I am using. I originally tried just having a table lookup for the Data End Date but if the site was active and the End Date said 'Current Data' PI AF would put 'No Data' since it is not in a DateTime format.
Thanks for any help!!