Figuring out if a date lies between two dates (SQL)

building semantic layer
18

Ideally, yes, you would solve this in the database level.

SELECT CAST(BOABSENCECALENDARLINE.FIRSTDAYOFABSENCE' AS DATETIME) [b]AS[/b] DateValue

You need to give the columns a name using AS.
https://bobj-board.org/t/72519

Mak 1 :uk: (BOB member since 2005-01-06)