Forum Discussion
Helper IIIdate table not working
alisonpappas , The table where you are joining the date from the date table. Check if that date have timestamp.
Let us say you are joining to start date of table1, check that the start date has timestamp or not. Best way to check is to change its data type to DateTime and choose a format that that has time and see do see any time other than 12:00 AM , if yes create a new date column
New Date = [Start Date].date
Or
New date = date(year([Start Date]),month([Start Date]),day([Start Date]))
Super Useralisonpappas , The table where you are joining the date from the date table. Check if that date have timestamp.
Let us say you are joining to start date of table1, check that the start date has timestamp or not. Best way to check is to change its data type to DateTime and choose a format that that has time and see do see any time other than 12:00 AM , if yes create a new date column
New Date = [Start Date].date
Or
New date = date(year([Start Date]),month([Start Date]),day([Start Date]))
alisonpappasamitchandak this was it! it came in as 7pm so making a new column changed to 12am and matched thank you all!