cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ljc New Member
New Member

Date Filter

Hi All,

 

Can anyone help me with this question please, "Filter the rows on the bi_salesFact query to include dates from January 1st, 2000. (Hint: Apply a Date filter in the Date column to import dates after December 31st, 1999. Before you can apply a date filter, you need to change the Date column's Data Type to Date)."
What is the right condition that I need to use in order for me to get the right answer? I followed the steps then go to date filters and use the condition "date is after 31/12/1999" then the years that showed up was only 2002 and 2003.