date

When this is placed in a cell, the values in that column are interpreted by the Pebble Stream compiler as dates, regardless of what Excel sets the type to.

When the date type is used, Pebble Stream expects text formatted as a string and will coerce that string into a number representing the Excel date.

Supported date formats are as follows (using March 03, 2021, as an example):

yyyy/MM/dd => 2021/03/20 yyyy-MM-dd => 2021-03-20 MM/dd/yyyy => 03/20/2021 MM-dd-yyyy => 03-20-2021

and

yyyy/M/d => 2021/03/20 yyyy-M-d => 2021-03-20 M/d/yyyy => 3/20/2021 M-d-yyyy => 3-20-2021

where

d is a numerical single-digit day. Examples include 3 and 31.

yyyy is a four-digit numerical year. Examples include 2022.

M is the numerical single-digit month. Examples include and 12.

MM is the numerical double-digit month. Examples include 03 and 12.

🚧

It is better to rely on Excel’s automated cell typing whenever possible.