cancel
Showing results for 
Search instead for 
Did you mean: 

Updating Date field

AnneMargarette
Contributor

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?

1 ACCEPTED SOLUTION

CRMSarah
Frequent Contributor

@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! 

View solution in original post

1 REPLY 1

CRMSarah
Frequent Contributor

@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!