Date format on exporting query to csv file from access 2007

[Matt]

Can any one suggest a solution??

I have a query which pulls some data and adds a date value, what I need to
do is export the query results to a csv file with the date as yyyymmdd I have
tried format(date(),"yyyymmdd") but it appears format is no longer available
in access 2007 queries. Is there a new approach to this that will achieve the
same result??

Any help appreciated

 

[Rick Brandt]

Can any one suggest a solution??

I have a query which pulls some data and adds a date value, what I need
to do is export the query results to a csv file with the date as yyyymmdd
I have tried format(date(),"yyyymmdd") but it appears format is no longer
available in access 2007 queries. Is there a new approach to this that
will achieve the same result??

Any help appreciated

If you're getting a message that Format() is not recognized then you have a
references problem. The Format function certainly still works in 2007.

 

[Matt .]

Rick, thankyou for the reply, my syntax in the query is

final_date: Format(Date(),"yyyymmdd")

I have used the exact same syntax in access 2003 with no issues is there something I'm missing

The message I get is:
"You omitted an operand or operator, you entered and invalid comma, or you entered text without surrounding it in quotation marks."

Any help is appreciated



Rick Brandt wrote:

Matt wrote:If you are getting a message that Format() is not recognized then
15-Feb-10

Matt wrote

If you are getting a message that Format() is not recognized then you have
references problem. The Format function certainly still works in 2007.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Creating a WPF Custom Control
http://www.eggheadcafe.com/tutorial...9-c0b45fb68b78/creating-a-wpf-custom-con.aspx

 

[Matt .]

Discovered the cause,

In regiional settings - standard formats - customise

I had changed the default filed seperator from a "," to a "|" access 2003 seems to cope with this fine but access 2007 doesn't like it when it comes to running butil in functions there may be a way round this but for a now I have changed it back

hope this helps some one wasting hours trying to work out in the future

Thanks again for you help Rick



Matt . wrote:

Syntax
17-Feb-10

Rick, thankyou for the reply, my syntax in the query is

final_date: Format(Date(),"yyyymmdd")

I have used the exact same syntax in access 2003 with no issues is there something I'm missing

The message I get is:
"You omitted an operand or operator, you entered and invalid comma, or you entered text without surrounding it in quotation marks."

Any help is appreciated

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Putting Twitter Realtime Search to Work
http://www.eggheadcafe.com/tutorial...24-c9960b55b669/putting-twitter-realtime.aspx