Report by Date

[civl_eng]

hi all, i want to create report from one date in form by vba, but its not working :

Dim FromDate As String
FromDate = "1368/10/27"
DoCmd.OpenReport "Project", acViewReport, , "[Date2]= #" & Format(FromDate, "yyyy/mm/dd") & "#"

[Date2] field is Short Text type.


can someone provide the correct method to use??


(Sorry for my poor english)

[aytee111]

Date2 as a string must have quotes, not "#" - those are for date types only. Also for FromDate, which is also a string, you cannot format it as you are doing. Why not just use "Date2='1368/10/27'"?

[civl_eng]

hey,, Thanks for correcting the code,,, i had chosen a wrong way and i didn't know that was so easy.
but now, how can i create report between tow date ?? for example between 1368/10/27 and 1368/10/29 .

thanks again.

[aytee111]

I'm not sure what those values are, they aren't real dates for Access.

But the syntax would be:
Date2 Between #" & date_from & "# AND #" & date_to & "#"

assuming all three fields are date type.

[civl_eng]

can we use between,and only in date type?
is there a way to create report between in range of string value??

my date is persian, but access does not support persian date, for this reason i use string type to field.


for this my problem i written this code but it is not correct :

DoCmd.OpenReport "Project", acViewReport, , "[Date2] BETWEEN '1368/10/27'" and '1368/10/29'"

Any help would be gratefully received.

[ArviLaanemets]

When you have your dates as text strings in format "yyyy/mm/dd", then BETWEEN must work (it doesn't work when order of year, month and day is different).

Try DoCmd.OpenReport "Project", acViewReport, , "[Date2] BETWEEN '1368/10/27' and '1368/10/29'"

[civl_eng]

thank you, If i want to use textbox and enter date to textbox then create report, i must use this code ???? :

DoCmd.OpenReport "Project", acViewReport, , "[Date2] BETWEEN 'Text_Start' and 'Text_End'"

(sorry for my poor english)