Hi. I have a text formatted date in mysql table that is from PayPal. I need to make a calc field to get it as a normal date field or something more reliable as a filemaker date format.
payment_date: 12:17:41 Feb 22, 2018 PST
my calcs so far:
payment_date_get_as_date: Feb 22, 2018
the calc: MiddleWords ( payment_date ; 2 ; 3 )
Need it to be something like: 2/22/2018
Appreciate some guidance.