Forum Discussion

ALeef's avatar
ALeef
Icon for Resolver II rankResolver 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
Icon for Resolver II rankResolver II
10 years ago

BTW I always use today() not now()

 

Does it make any difference?

ALeef's avatar
ALeef
Icon for Resolver II rankResolver 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!