https://mycommunity.validity.com/t5/demandtools/updating-date-field/m-p/804#M400 <P><a href="https://mycommunity.validity.com/t5/user/viewprofilepage/user-id/470">@AnneMargarette</a>&nbsp;Is this from, say, an excel file? I always format it like this:&nbsp;<SPAN>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!&nbsp;</SPAN></P> Wed, 17 May 2023 19:04:07 GMT CRMSarah 2023-05-17T19:04:07Z https://mycommunity.validity.com/t5/demandtools/updating-date-field/m-p/802#M398 <P>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?</P> Wed, 17 May 2023 18:40:03 GMT https://mycommunity.validity.com/t5/demandtools/updating-date-field/m-p/802#M398 AnneMargarette 2023-05-17T18:40:03Z https://mycommunity.validity.com/t5/demandtools/updating-date-field/m-p/804#M400 <P><a href="https://mycommunity.validity.com/t5/user/viewprofilepage/user-id/470">@AnneMargarette</a>&nbsp;Is this from, say, an excel file? I always format it like this:&nbsp;<SPAN>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!&nbsp;</SPAN></P> Wed, 17 May 2023 19:04:07 GMT https://mycommunity.validity.com/t5/demandtools/updating-date-field/m-p/804#M400 CRMSarah 2023-05-17T19:04:07Z