Forum Discussion
Solved
Long Date Not Recognizing Related Table Date
Long story short I have a table of data that includes a column with a date. I want to convert to fiscal dates, so created a table that has those dates, qurters, months correctly. Have a one to manny ...
Machi6108 You could create a calculated column in your table like:
Date Midnight = DATE(YEAR([Date]),MONTH([Date]),DAY([Date]))
This worked thank you!