FavoriteDenise Zarzuela (PepUp Tech) asked in #Data ManagementApr 4, 2021, 12:10 AMTime field format for Dataloader insertHow do I format time to differenciate AM from PM? For example how do I have to format the following times to upload records via Dataloader: 9:00am 9:00pm3 answersSortSort by DateSort by Most HelpfulSort by DateLoad more comments...Seyran MammadovApr 4, 2021, 12:35 AMFor Time field type, you can try the following: For 9:00AM -------> 09:00:00.123Z For 9:00PM -------> 21:00:00.123ZAdd a commentWrite an answer...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Seyran MammadovApr 4, 2021, 12:35 AMFor Time field type, you can try the following: For 9:00AM -------> 09:00:00.123Z For 9:00PM -------> 21:00:00.123Z