Rabu, 28 Agustus 2013

[MS_AccessPros] Re: Slightly Off Topic - Date format.

 

Hi Robin,

Paste the contents of the Function that you are using
to output the Date.

You can change the format by using the Function,
Result = Format(The name of your date field, "d mmm yyyy")

You could test it in the Debug Window with,
?Format(Date(), "d mmm yyyy")
Or
?Format(Date() + 4, "d mmm yyyy")
to give you today's date or today+4's date.

Hope that helps.

Regard, Clive.

--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple <robinski@...> wrote:
>
> As many of you already know I am a 'user' of Access with limited
> personal ability.
>
> I use an Access database on a remote server, I use a code generator
> to prepare web pages to view the web pages. This has been running for
> eight years and has proved very reliable.
>
> The code generator allows me to 'write' functions which, in this
> case, change the output of a date field that is generated in
> dd/mm/yyyy format. We use 1 Jan 2013 format.
>
> Writing the function is Greek to me!
>
> My question is which mailing list or forum is the correct place to
> seek assistance?
>
> Many thanks,
>
> Robin Chapple
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar