Forum Discussion
Removing Time stamp from date
Hi Anonymous ,
Please try the following methods and check if they can solve your problem:
1.Ensure that the date part is considered, removing the time component.
2.Try the following DAX formula.
Week of Due Date = "Week of" & " " & FORMAT('BAH Task Tracker'[Due Date] - WEEKDAY('BAH Task Tracker'[Due Date],2) + 1, "dd/mm/yyyy")Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This solved my issue! Thank you so much!
Anonymous
in powr query, change datatype yo date instead of datetime .
if you need the time, in other reports, then create a duplication of this column, and leave it as datetime,
and the original one you can change its datatype to date .
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
that did not work for me. I removed the wording "Week of" and then I changed the datatype to date, but once I added the wording back in there were still several instances of the time