Hi Erik,
Explanation:
It is not possible to change the Date Format from this Drop Down.
This is a part of Enumeration Named # dateFormat which is a part of Schema # xtk:dataTransfer.
As this is the Out Of The Box Schema, this can't be changed.
But, there is a workaround to change the date format to the one you want.
Solution:
After the DataLoading Activity, use one JavaScript Activity, and write the below code to change the Date Format.
//Select The Date Coming From The DataLoading Activity
var query = xtk.queryDef.create
(
<queryDef schema={vars.targetSchema} operation="select">
<select>
<node expr="@Date"/> // Name Of Your Date Column In DataLoading Activity
</select>
</queryDef>
);
var res = query.ExecuteQuery();
var date; // Variable To Capture New Date After Format Change
for each (var w in res)
logInfo("Date Before Changing The Format : "+w.@Date);
{
date = formatDate(w.@Date,"%4Y-%2M-%2D"); //Put The Desired Date Format You Want. (Ex. %4Y-%2M or %2D-%2M)
logInfo("Date After Changing The Date Format: "+date);
}