SQL in Matlab: Create a date with query

Question

i have daily data:

     Isin             Date          Price   
 ______________    ____________    __________ 
'GB00B1YW4409'    '31.12.1999'    [688.1300]
'GB00B1YW4409'    '03.01.2000'    [688.1300]
'GB00B1YW4409'    '04.01.2000'    [690.6200]
'GB00B1YW4409'    '05.01.2000'    [666.9500]
'GB00B1YW4409'    '06.01.2000'    [650.7600]
'GB00B1YW4409'    '07.01.2000'    [663.2200]
'GB00B1YW4409'    '10.01.2000'    [694.3500]
'GB00B1YW4409'    '11.01.2000'    [683.7700]
'GB00B1YW4409'    '12.01.2000'    [675.0500]
'GB00B1YW4409'    '13.01.2000'    [664.4600]

I want to have a list of the first of every month. Something like:

'01.01.2000'
'01.02.2000'
'01.03.2000'

I thought of something like

select distinct date(year(List.Date),month(List.Date),01) as Data from List

But i get an error message:

Error using COM.ADODB_Connection/Execute
Invoke Error, Dispatch Exception:

Source: Microsoft Access Database Engine

Description: Wrong number of arguments used with function in query expression

'date(year(List.Date),month(List.Date),01).

What am i doing wrong?

Gordon Linoff · Accepted Answer · 2018-01-18 19:47:11Z

1

The date() function in MS Access returns the current date.

You are looking for dateserial():

select distinct dateserial(year(List.Date), month(List.Date), 01) as Data
from List;

answered Jan 18, 2018 at 19:47

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL in Matlab: Create a date with query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related