I've reviewed many posts but haven't been able to find one that shows me how to correct my imported text from YYYYMMDD to date format MM-DD-YYYY. (I'm a beginner. Feel free to also tell me who your favorite YT trainer is.)
+24I suggest you create a formula date field with this formula. For ease of reading I make use of Formula Variables.
var text YYYYMMDD = [insert your imported field here];
var number YYYY = ToNumber(Left($YYYYMMDD, 4));
var number MM = ToNumber(Mid($YYYYMMDD, 5,2));
var number DD = ToNumber(Right($YYYYMMDD,2));
Date($YYYY,$MM,$DD)
As for YouTube Training, The fun videos are put out by Sharon Faust, aka The Quickbase Junkie.
But Quickbase University has a complete training program which can lead to Certification.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
