date problems

[tinoco]

hello!
i'm building a form where the users can see the visits of the members by period.The user fill in the start period date and the finish period date and then appears a list between those dates.
i'm able to make a querie that shom me the data between the week of the start period and the week of the finish period but i'm not able to put the period exactly between the dates that the user introduced.
i tryed to use the datevalue() function but it didn't work because is to complex to call it from a form.
Anyone can tell me how should i do this?
thank you very must

 

[grande]

Hmmm...

How are you getting it to show you the week?

 

[tinoco]

hello
i use the format function
format(tablename;"ww")between format(startdate;"ww") and format(finishdate;"ww")
i hope this help
thank you

 

[PHV]

i'm not able to put the period exactly between the dates that the user introduced
Am I missing something ?
[table date field] Between [startdate] And [finishdate]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[grande]

What format are the users entering the date as?

Try PHV's solution, I'm pretty sure that'll work.

 

[tinoco]

hello!
I tryed already PHV's soluction and it works if you use the datevalue function. The problem is when you call the querie from the form it doesn't work anymore..
The users enter their data in the short date format.
I find the soluction already! I use the iif() function so i can select the month that i want and then I can say that in that month the days must be bigger than the day that is in the form.
Thank you a lot for your time!
thanks