Question: You have received a file from a system that only provides two digits for the year. You have been advised that a date field in
You have received a file from a system that only provides two digits for the year. You have been advised that a date field in this file contains dates before, on and after January How do you ensure that the dates are properly interpreted in Analytics?
A
Manually input the format of the year as CYY where C is the Century and is a for the th century and a for the st century.
B
Bring the field in as a character type and convert it to a Julian date using CTOJfieldname, where is the correct Julian format.
C
Configure the start of century option.
D
Configure the end of century option.
E
Check the YKCompliance option in Analytics. By default it is unchecked.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
