3 Replies Latest reply on Feb 17, 2014 5:15 PM by CJ Nencetti

    Is there an easy way to join date and datetime fields?

    . Bld

      I want to join a fiscal calendar into a table using a date.  The problems is the date table only returns the date where the field I need to join to is a date time field.  They only join when the datetime field is midnight since it defaults to 0:00 for the time.

       

      Is there an easy work around for this or would I need to have the field changed in the database?

       

      Thanks!