I need to join the two "times" below. I have already joined the "number" fields
in the Excel Spreadsheet that I imported into the Crystal Report, however I cannot
join the "Date" field. Any idea on how to join Excel Date with MS SQL Server Date?
In the EXcel Table that I import into Cystal Reports the date is formatted like this
12/30/1899 5:00:00AM
(i.e., the actual spreadsheet only contains the time but for some reason when I import
into Crystal Reports it puts "12/30/1899" on the time)
In the MS SQL Server Database table the date is formatted like this
5/27/16 5:00 am
How can I join just the "times" in both the Excel Table and the database table?
In other words 5:00am in Excel joined to 5:00am in the MS SQL Database.
Thanks for any assistance.
in the Excel Spreadsheet that I imported into the Crystal Report, however I cannot
join the "Date" field. Any idea on how to join Excel Date with MS SQL Server Date?
In the EXcel Table that I import into Cystal Reports the date is formatted like this
12/30/1899 5:00:00AM
(i.e., the actual spreadsheet only contains the time but for some reason when I import
into Crystal Reports it puts "12/30/1899" on the time)
In the MS SQL Server Database table the date is formatted like this
5/27/16 5:00 am
How can I join just the "times" in both the Excel Table and the database table?
In other words 5:00am in Excel joined to 5:00am in the MS SQL Database.
Thanks for any assistance.