4 Replies Latest reply on Dec 10, 2019 11:17 PM by Aslı Noyan

    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?