Date

[Thedon123]

i would to set the default value of a field of type date/time to display just the current month and year automatically. How would i go about doing that.

 

[smed]

Set the Field Definition to :

Data Type : Date/Time
Format : mm/yyyy
Default Value : =Date()


Smed

 

[Thedon123]

I have done that but when i go to a query. The prompt i have set asks the user to enter the month/year it does not display any results for that month. this is because it wants the day also.

still need help.

 

[smed]

I think I understand what you are trying to do.

Create temporary date field and base the criteria on that field not the original date


TempDate :Mid([OriginalDate],4)

This willremove the "dd/" from "dd/mm/yyyy". Therefore leaving just the "mm/yyyy" which you can specify a month/year criteria against.

Hope this works

Smed

 

[Thedon123]

Thanks mate that brilliant it works

 

[Thedon123]

I have found a site that helps with this.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q88657&