By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Update Query - search for "/"

P: 76
Simple, I'm sure...

I'm trying to run an update query, where I am looking to update "/" with "-".

I can't figure out how to set the criteria/update to fields correctly for these special characters.
Apr 8 '10 #1

✓ answered by TheSmileyCoder

Thats the way dates are stored. What you want is do DISPLAY them differently.
Try:
format([JoinDate],"yyyy-mm-dd")


EDIT:
If you set the format property in the table itself, it will carry over to all new reports/forms.

Share this Question
Share on Google+
5 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
Replace(strInput,"/","-")
Apr 8 '10 #2

P: 76
table: tblMain
field: joinDate.

Trying to change the "/" to "-".
Dates are in 2010/04/01 format and I need them to be in 2010-04-01 format.
I was using the qry builder in access and trying to use the "Update" qry.
Apr 8 '10 #3

TheSmileyCoder
Expert Mod 100+
P: 2,321
Thats the way dates are stored. What you want is do DISPLAY them differently.
Try:
format([JoinDate],"yyyy-mm-dd")


EDIT:
If you set the format property in the table itself, it will carry over to all new reports/forms.
Apr 8 '10 #4

P: 76
Yeah..I'm aware of that.
The thing is, I'm exporting this table into a CSV that is being imported into a *proprietary* system. They require this date format. The field is text, so it's not a true date format on either db.
Apr 8 '10 #5

P: 76
Thanks for your help!
Apr 8 '10 #6

Post your reply

Sign in to post your reply or Sign up for a free account.