Date Table Columns


#1

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


#2

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


#3

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.

https://www.filepicker.io/api/file/aKoIWQb0Tpe8rAAbGwv6

Guy


#4

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


#5

Hi Guy,

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

Thanks
Elizabeth