Forum Discussion
MarkShnier__You
2 years agoQrew Legend
I 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.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------