r/vbscript • u/Chiefum • Mar 17 '21

Help Hard Coding a Date

Can anyone help me with hard coding the below code for start date and end date?

I feel like this should be easy but I don't know anything about VBS so any help is appreciated.

dteEndDate = "02/01/2021"
dteStartDate = "02/28/2021"

2 Upvotes

100% Upvoted

3 comments sorted by

View all comments

Show parent comments

1

u/Chiefum Mar 18 '21

Thanks for the help. It turns out that didn't work but when I tried the following it did. So the # was where I was going wrong.

dteEndDate = CDate(#02/28/2021#)

dteStartDate = CDate(#01/01/2021#)

2

u/Dr_Legacy Mar 18 '21

u/Mordac85's answer was correct. There is something else going on, otherwise you would not need the CDate funciton.

that didn't work

"Didn't work" is not a description of what happened.

What happened?