Calendar: DECLARE FIELD DEFINITION TAGGED '$date' Parameters first_month_of_year = 1 Fields Year($1) As Year Tagged ('$numeric'), Month($1) as Month Tagged ('$numeric'), Date($1) as Date Tagged ('$date'), Week($1) as Week Tagged ('$numeric'), Weekday($1) as Weekday Tagged ('$numeric'), DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric');
DERIVE FIELDS FROM FIELDS EndDate USING Calendar;
===========
Above code is generating derived fields only with below two date values when I used them in sheet.I want to know what happened to other four Enddate values and why they are not reflected in sheet.
Should be 'DD/MM/YYYY' to match your data, but maybe it's defined as 'MM/DD/YYYY', so the first numerical digits are interpreted as month, i.e. this only works for starting numbers <= 12.
In this case try changing your DateFormat variable in the script:
SET DateFormat='DD/MM/YYYY';
Or instead load EndDate using the Date#() interpretation function:
Should be 'DD/MM/YYYY' to match your data, but maybe it's defined as 'MM/DD/YYYY', so the first numerical digits are interpreted as month, i.e. this only works for starting numbers <= 12.
In this case try changing your DateFormat variable in the script:
SET DateFormat='DD/MM/YYYY';
Or instead load EndDate using the Date#() interpretation function:
