Posted: 29 Jan 2021 18:21 EST Last activity: 1 Feb 2021 8:58 EST
Unable to add date value into a date property of a data type via activity.
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.
***Edited by Moderator: Pooja Gadige to add platform capability tag***
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.