Forum Discussion
Solved
Combining 2 Date Fields into 1
I have 2 date fields in the same table in my database: Date Field 1 and Date Field 2. Date Field 1 always contains data; Date FIeld 2 sometimes contains data. What I'd like to do is create a new da...
What about creating a custom column using the Query Editor? You could add a column with the following statement (replace the text in green with your field names:
if [Date 2] <> null then [Date 2] else [Date 1]
It would result in something like this:
What about creating a custom column using the Query Editor? You could add a column with the following statement (replace the text in green with your field names:
if [Date 2] <> null then [Date 2] else [Date 1]
It would result in something like this: