Hi, I have linked ms access to orcale to run a query, the date in orcale is in this format 20140101, i have tried to convert the date in the query like that but it's not working. format(mydate,"yyyy/mm/dd". Does anyone know how to do it. Thanks.
Ms Access linked to Oracle
- Thread starter mr moe
- Start date
pr2-eugin
Super Moderator
- Local time
- Today, 20:04
- Joined
- Nov 30, 2011
- Messages
- 8,494
Try something like..
Code:
? [URL="http://www.techonthenet.com/access/functions/date/dateserial.php"]DateSerial[/URL]([URL="http://www.techonthenet.com/access/functions/string/left.php"]Left[/URL]("20140101", 4), [URL="http://www.techonthenet.com/access/functions/string/mid.php"]Mid[/URL]("20140101", 5,2), [URL="http://www.techonthenet.com/access/functions/string/right.php"]Right[/URL]("20140101", 2))
01/01/2014looks perfect thanks 
the only problem is that when I try to query using the right format, the query doesnt' give me any results, for example I put 01/01/2014 but I dont get any results, eventhough the funcation has made it look like 01/01/2014, any tips , thanks.
the only problem is that when I try to query using the right format, the query doesnt' give me any results, for example I put 01/01/2014 but I dont get any results, eventhough the funcation has made it look like 01/01/2014, any tips , thanks.
