Date Table Columns

ElizabethTachjian · February 6, 2019, 1:22am

Hi,

Is it best to for the columns in the date table to be formatted as whole number or text. Except for actual full dates. Or does it not matter.

Elizabeth

GuyJohnson · February 6, 2019, 11:26am

Elizabeth,

I always use the Date Table that Sam has provided. This has never needed any columns re-formatted and it works just fine.

Guy

GuyJohnson · February 6, 2019, 11:31am

Elizabeth,

This is the text document with the code for that Date Table.

Cut and Paste into the Query Editor > Advanced Editor then set the beginning and ending dates.

Guy

GuyJohnson · February 6, 2019, 2:58pm

Elizabeth,

I missed part of the path to enter the Date text.

Open Query Editor >Select New Blank Query > Then advanced Editor

I deeply apologize for my mistake.

Guy

ElizabethTachjian · February 6, 2019, 8:04pm

Hi Guy,

ok. I will leave the data type as it, whole numbers.

Thanks
Elizabeth