EazyBI - User Defined Measure for Dates

Question

I am attempting to complete a CASE statement in EazyBI to enter 0 when there is a certain date field containing a date of Jan 01 2000.

How can I take a measure (Date Introduced to Production - which is a datetime) and compare it to a string like "Jan 01 2000"?

Fabian Lim · Answer

Hi Kinsey,

You can use the DateCompare function which is explained here: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datecompare

Regards