I want to do a lookup on date column. My lookup date is of type smalldatetime, and my date is of type datetime (date with time component). My lookup is failing because of incompatible data types.
How do I perform the lookup with date columns having date and time components?
Switch to your source component to use a query and then use the cast operator to cast the datetime column to smalldatetime in the query of you source component.
Rafael Salas
No comments:
Post a Comment