Date Specification

 

A Date can be specified as either

 

1. an Excel Date
Examples:

=Q("msft",,DATE(2013,1,1))


 

=Q("msft",,D1,)

 


 

or

 

2. in quotation marks in the format "yyyy-MM-dd" where MM can be just M and DD can be just D and the separator - can be also /.

 

=Q("msft",,"2013-01-01")

 

 

=Q("msft",,"2013-1-1")

 

=Q("msft",,"2013/1/1")

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017