I’m a fairly new Toad user. Prior to Toad I had been building queries in Access 2003.
The hardest part for me to transition to is the calculated field portion of Toad. The data warehouse that I use stores dates in YYYYMMDD format. To convert these in access I created this function:
DateValue(Mid(,2) & “/” & Left([date],4)) which translates to MM/DD/YYYY
I’ve searched for some kind of reference to describe all the functions available to Toad with no luck. With Access, I used this website very frequently: http://www.techonthenet.com/access/functions/index.php
So, my questions are (1) is there any refrence material similar to the link above for Toad? (2) Is there any function that I can use to convert YYYYMMDD to a format that Toad will recognize as a date?
Appreciate any help.