Forum Discussion

ALeef's avatar
ALeef
Resolver II
10 years ago

Possible Tip/Trick: Dynamic Date Dimension Table

I'm going to share the dynamic date dimension table I built, hopefully it is useful to someone!  I named it DateTable for this tutorial, and my fact table FactTable.   The table is built using the ...
Tips and Tricks
RJ's avatar
RJ
Resolver II
10 years ago

BTW I always use today() not now()

 

Does it make any difference?

ALeef's avatar
ALeef
Resolver II
10 years ago

TODAY() only returns a day, and sets the time to 12:00am.  For this instance, I don't think it matters, but I use timestamps regularly, so that is what I'm in the habit of.

 

Good question!