Willow Tips

Tip #2000-4: Formatting Dates Correctly with Live Data

Now it really is a date, but it doesn't yet LOOK like one

The date field is now downloading in serial number format; i.e., the number of days since January 1, 1900. Next we'll format the cell to display the serial number in a traditional date form.