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

Formatting Inputed Date

MMcCarthy
Expert Mod 10K+
P: 14,534
Can someone have a look at post# 10 in the following question in the Access forum.

Thanks

Mary

http://www.thescripts.com/forum/thread598380.html
Feb 7 '07 #1
Share this Question
Share on Google+
4 Replies


jhardman
Expert 2.5K+
P: 3,405
try:
Expand|Select|Wrap|Line Numbers
  1. correctDate = day(request("mydate1")) & "-" & monthName(month(request("mydate1"))) & "-" & year(request("mydate1"))
  2.  
let me know if this works
Feb 7 '07 #2

jhardman
Expert 2.5K+
P: 3,405
day, month, and year functions extract those parts of the date (but I think which part is which is determined by server settings). monthName(month) takes an integer argument and outputs a month name.
Feb 7 '07 #3

Expert 100+
P: 1,892
You should probably follow the link and append your post to the original thread.

Aric
Feb 7 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
You should probably follow the link and append your post to the original thread.

Aric
This question has now been moved to the ASP forum.

Format input date for passing to database

Mary
Feb 8 '07 #5

Post your reply

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