Unable to add date value into a date property of a data type via activity.
Hi Community,
We are having some issues with an activity where we are trying to add/update a record for a data type but when we are injecting the date value to a date property in the data type, the format is always incorrect(something like 20210129+ instead of 20210129) so the table is not accepting the value.
Is it even possible to add a record via activity(DataSet-Execute) to a date property(not date/time)? Does anyone know how to add value to a date property of data type record via activity?
Help is much appreciated.
Thanks, Masato
SCSK USA Inc
US
Hi Marc,
Thank you for your help! We tried setting the date property as a value and also OOTB expressions for standard datetime. Eitherway, the date shows as yyyyMMdd+ instead of MMddyyyy so we are scratching our heads here if we should ever set up a data type's property as date instead of datetime. If you look the screenshot this is what happens if you add records with both methods.
Thanks, Masato