@dsap wrote:
We're trying to schedule listings using the ScheduleTime header and wondering if there is an easy way to create a column template to easily change the date and time between item uploads. We seem to have issues with excel reformatting. We used an equation but that also didn't seem to work. We want to be able to easily change the date and upload time to every 10 seconds or so for 25 items at a time. Thanks in advance for any help. Dave
Hello @dsap,
The date and time have to be in this format:
YYYY-MM-DD HH:MM:SS
The time you enter would be in Greenwich Mean Time (GMT).
Excel tends to change the format for date (for example, 2024-10-28 may be changed 10/28/2024). So you should watch for that. To avoid that from happening, you could enter the letter "T" between the day and hour, for example:
2024-10-28T16:30:00
