Hi everyone, I'm struggling to get an answer for this . I need help. So, I have a invoice date table without the time how do i create a current time using this date table that i have?. So far, I manage to create a current date out of this date table that I have.
here's the formula using measures for current date:
and the outcome for current date using the date data table :
But now the problem is, im not sure on how to do the current time using the existing date data table that i have? Anyone pls help me!