UFN_DATE_THISFISCALYEAR_FIRSTDAY returns NULL when passed a date with time parameter

UFN_DATE_THISFISCALYEAR_FIRSTDAY returns NULL when passed a date with time parameter only on the last day of the month. e.g.

select

dbo.UFN_DATE_THISFISCALYEAR_LASTDAY('2012-10-31 2:30:33',1)any other date works as expected this is also true of UFN_DATE_THISFISCALYEAR_LASTDAY
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.9.1001, patch 104
 2.94.1524, patch 23 ; 2.9.1001, patch 123 ; 2.91.1535, patch 87 ; 2.93.2034, patch 44

Was this article helpful?