Trying to look up fiscal month from another table. looking at Event Date and fiscal table has a start and end date. Where is my formula incorrect??
fMonth: DLookUp("[fiscalMonth]","tblFiscalDates","[EVENT DATE]<=[tblFiscalDates]![datWeekend] And [EVENT DATE]>=[tblFiscalDates]![datWeekStart]")
thanks in advance!!
fMonth: DLookUp("[fiscalMonth]","tblFiscalDates","[EVENT DATE]<=[tblFiscalDates]![datWeekend] And [EVENT DATE]>=[tblFiscalDates]![datWeekStart]")
thanks in advance!!