Having / to seperate dates in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a Report that when runs a date has to be entered (via a query in the
background) is there a way of having the / (that i use to seperate the
DD/MM/YYYY )already there when the operator enters the date.

Thanks in advance
Sean
 
Only if you build a form and use edits on the field. Much more complex.

The advantage of leaving it like it is is that you have some options. For
example, any time you are prompted for the date, you can leave off the year
and it will assume the current year. You can include zeros or not.

If your users want to simply enter 01012006, then you could let them, but
you'd have to do some fancy statements in your query to turn it into a date,
and you'd probably have to have them use the exact 8-digits, so they'd lose
some of the advantages listed in the second paragraph above.
 
Back
Top