This content has been marked as final. Show 2 replies
I am using the following script to load a timestamp as its correct year and date:
LOAD DATE ([ContractStartDate],'MM/DD/YYYY') AS ContractStartDate
,DATE([ContractStartDate],'YYYY') AS ContractStartYear
,DATE([ContractStartDate],'MM') AS ContractStartMonth
However, when I show the ContractStartYear as a list, it returns the same year multiple times, and even though each one looks the same, they actually pull a single day's worth of data, not the whole year.
2001 <--only refers to 01/05/2001
2001 <--only refers to 05/04/2001
2001 <--only refers to 07/12/2001 etc...
Is there something I need to specify in the script so that it will instead yield the following:
2001 <--refers to entire year of 2001
2002 <--refers to entire year of 2002 etc...