I have a database in which I paste info from SAP to combine with manual entered times to give productivity. The start and end times are entered as general time format (mm/dd/yyyy hh:mm:ss AM) and the confirmed time from SAP is downloaded as format (hh:mm:ss AM) and also contains a date (mm/dd/yyyy).
If, in my query, I try to set the criteria for the time from the SAP table as Between [StartTime] And [EndTime] it gives me nothing because the date is not included with the time.
I wrote a query for the SAP table which updates a new field "JoinTime" to "[CreationDate]&" "&[CreationTime]". This makes the field LOOK like it should for general date format; however, this query does not work unless the field is formatted as TEXT. If I try to format as DATE, it will not update due to type conversion error.
The query which will give me my end result does not work because of the formats being different.