Print a Long Date format in an expession

[Arjan]

Hello,

I have a question; I would like to print a date in an expression i.e.
expr1: "the following date "&[date]&" was very sunny..."

As a result it prints: the following date 03/20/2006 was very sunny...
However I want the date to be printed in long (Long Date format) i.e. the
following date Monday, March 20, 2006 was very sunny...

Does anybody know how I can do this?

Thanks in advance!!

Arjan
the Netherlands

 

[John Spencer]

Use the format function

Format([Date],"Long Date")

 

[BruceM]

Along with what John wrote, if [Date] is the name of the field you should
change it (to [EventDate] or something like that, maybe). "Date" is a
reserved word in Access. For a partial listing of reserved words, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187

 

[Arjan]

Hi John/Bruce,

Thanks for your reply. However, I can't get it to work..

the [date] I use in: expr1: "the following date "&[date]&" was very
sunny..." is actualy called: aankomst datum, so it should be this:

expr1: "the following date "&[aankomst datum]&" was very sunny..."

should it still work then? because I'm afraid the [date] is actually the
real date.. what I have now is:
expr1: "the following date "& Format([aankomst datum], "Long Date") &" was
very sunny..."

but this doesn't work..
Can you help me out?

thanks!!

Arjan.

Along with what John wrote, if [Date] is the name of the field you should
change it (to [EventDate] or something like that, maybe). "Date" is a
reserved word in Access. For a partial listing of reserved words, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187

Hello,

I have a question; I would like to print a date in an expression i.e.
expr1: "the following date "&[date]&" was very sunny..."

As a result it prints: the following date 03/20/2006 was very sunny...
However I want the date to be printed in long (Long Date format) i.e. the
following date Monday, March 20, 2006 was very sunny...

Does anybody know how I can do this?

Thanks in advance!!

Arjan
the Netherlands

 

[BruceM]

Maybe the language settings make a difference. Try creating a text box
bound to a date field, and select the Long Date format. If different words
are used, try those words instead in your expression. If you select the
Long Date format in the text box, does the date appear in that format?

Hi John/Bruce,

Thanks for your reply. However, I can't get it to work..

the [date] I use in: expr1: "the following date "&[date]&" was very
sunny..." is actualy called: aankomst datum, so it should be this:

expr1: "the following date "&[aankomst datum]&" was very sunny..."

should it still work then? because I'm afraid the [date] is actually the
real date.. what I have now is:
expr1: "the following date "& Format([aankomst datum], "Long Date") &" was
very sunny..."

but this doesn't work..
Can you help me out?

thanks!!

Arjan.

Along with what John wrote, if [Date] is the name of the field you should
change it (to [EventDate] or something like that, maybe). "Date" is a
reserved word in Access. For a partial listing of reserved words, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187

Hello,

I have a question; I would like to print a date in an expression i.e.
expr1: "the following date "&[date]&" was very sunny..."

As a result it prints: the following date 03/20/2006 was very sunny...
However I want the date to be printed in long (Long Date format) i.e. the
following date Monday, March 20, 2006 was very sunny...

Does anybody know how I can do this?

Thanks in advance!!

Arjan
the Netherlands

 

[John Spencer]

Also, your argument delimiter may be a semi-colon ";" instead of a comma
",".

Maybe the language settings make a difference. Try creating a text box
bound to a date field, and select the Long Date format. If different
words are used, try those words instead in your expression. If you select
the Long Date format in the text box, does the date appear in that format?

Hi John/Bruce,

Thanks for your reply. However, I can't get it to work..

the [date] I use in: expr1: "the following date "&[date]&" was very
sunny..." is actualy called: aankomst datum, so it should be this:

expr1: "the following date "&[aankomst datum]&" was very sunny..."

should it still work then? because I'm afraid the [date] is actually the
real date.. what I have now is:
expr1: "the following date "& Format([aankomst datum], "Long Date") &"
was
very sunny..."

but this doesn't work..
Can you help me out?

thanks!!

Arjan.

Along with what John wrote, if [Date] is the name of the field you
should
change it (to [EventDate] or something like that, maybe). "Date" is a
reserved word in Access. For a partial listing of reserved words, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187

Hello,

I have a question; I would like to print a date in an expression i.e.
expr1: "the following date "&[date]&" was very sunny..."

As a result it prints: the following date 03/20/2006 was very sunny...
However I want the date to be printed in long (Long Date format) i.e. the
following date Monday, March 20, 2006 was very sunny...

Does anybody know how I can do this?

Thanks in advance!!

Arjan
the Netherlands

 

[Arjan]

John, Bruce,

The semi-colon did the trick... Thank you guys!!!

Arjan

Also, your argument delimiter may be a semi-colon ";" instead of a comma
",".

Maybe the language settings make a difference. Try creating a text box
bound to a date field, and select the Long Date format. If different
words are used, try those words instead in your expression. If you select
the Long Date format in the text box, does the date appear in that format?

Hi John/Bruce,

Thanks for your reply. However, I can't get it to work..

the [date] I use in: expr1: "the following date "&[date]&" was very
sunny..." is actualy called: aankomst datum, so it should be this:

expr1: "the following date "&[aankomst datum]&" was very sunny..."

should it still work then? because I'm afraid the [date] is actually the
real date.. what I have now is:
expr1: "the following date "& Format([aankomst datum], "Long Date") &"
was
very sunny..."

but this doesn't work..
Can you help me out?

thanks!!

Arjan.





"BruceM" <[email protected]> schreef in bericht
Along with what John wrote, if [Date] is the name of the field you
should
change it (to [EventDate] or something like that, maybe). "Date" is a
reserved word in Access. For a partial listing of reserved words, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187

Hello,

I have a question; I would like to print a date in an expression i.e.
expr1: "the following date "&[date]&" was very sunny..."

As a result it prints: the following date 03/20/2006 was very sunny...
However I want the date to be printed in long (Long Date format) i.e.
the
following date Monday, March 20, 2006 was very sunny...

Does anybody know how I can do this?

Thanks in advance!!

Arjan
the Netherlands