Print a Long Date format in an expession

A

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
 
A

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.





BruceM said:
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 said:
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
Click to expand...
Click to expand...
 
B

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?

Arjan said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
J

John Spencer

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


BruceM said:
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?

Arjan said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
A

Arjan

John, Bruce,

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

Arjan


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


BruceM said:
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?

Arjan said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top