Updating Date field

[AnneMargarette]

I am new to DTV and have been using the legacy DT through 6yrs of my employment. I have been updating date fields using this format MM/DD/YYYY using legacy DT with no issues. When I tried the same using DTV, the records were updated but it shows the UK date format which is DD/MM/YYYY. Do you know how I can continue to update in American date format MM/DD/YYYY?

[CRMSarah · Accepted solution]

@AnneMargarette Is this from, say, an excel file? I always format it like this: YYYY-MM-DDThh:mm:ssZ to be super duper certain it goes in correctly. Let me know if you're not doing it from an excel spreadsheet and I'll put some more thought into it!