Error: Expected end of statement (How to constant Date)

[VAer]

See attached error.

I am trying to pull historical stock data for STOCKHISTORY function, there are many places using the code STOCKHISTORY function.

I need to adjust the date range to pull different range of data, but instead of adjusting code in so many places, I would like to use two public variable StartDate and EndDate . Therefore, I only need to adjust these two variable each time when I made the change. For example, I may want to change StartDate to Today()-80 and change EndDate to Today()-15 next time.

How to define two date variable?

Thanks.

[XLent]

edit: removed - as, per Greg, this wouldn't work!

[Greg M]

Hi there,

You can't include something which isn't a constant value in a Const declaration statement.

You CAN combine constant values, e.g.:

Please Login or Register  to view this content.

but, as you've found out, including a non-constant value will produce the error you describe.

Hope this helps.

Regards,

Greg M


P.S. Just for information, when I tried to compile your code, the first instance of "Today" was highlighted, and the error message said "Sub or Function not defined".

[VAer]

Hi there,

You can't include something which isn't a constant value in a Const declaration statement.

You CAN combine constant values, e.g.:

Please Login or Register  to view this content.

but, as you've found out, including a non-constant value will produce the error you describe.

Hope this helps.

Regards,

Greg M

Ok, thanks. Then how can I declare 8/15/2021 as constant date? How to write it correctly without error. It is okay to replace Today() with a firm date. If I still want to use public variables StartDate and EndDate.

[Greg M]

Hi again,

Something like the following might do what you need:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

[VAer]

Hi again,

Something like the following might do what you need:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

Thanks much!

[Greg M]

Hi again,

Many thanks for your very prompt feedback.

You're welcome - glad I was able to help.

Regards,

Greg M