SQL Command -Combing 2 different date fields

[shaleen7]

I need to combine 2 queries into a SQL command. The problem is I have to combine two different date fields.

SQL command:
Tableapp.appdate[/color red], Tableapp.appno, tablecountry.countryname, tablename.lastname
from Table.appno, table.country, table.name
UNION
Table.app.pubulicationdate[/color red],Tableapp.appno, tablecountry.countryname, tablename.lastname
from Table.appno, table.country, table.name

Tableapp.appdate and Table.app.pubulicationdate are considered applications. I need to combine both fields so I can count the number of apps in each month.

How can I accomplish this?

Thanks

 

[bdreed35]

What version of CR are you using?

Are both Tableapp.appdate and Table.app.pubulicationdate date datatypes?

~Brian

 

[shaleen7]

Yes.

 

[bdreed35]

You still didn't mention what version of CR you are using. You should also provide information on how the appno, country, and name tables are joined.

~Brian