AnsweredAssumed Answered

How to calculate this date

Question asked by seaserpent on Feb 23, 2018
Latest reply on Feb 23, 2018 by fmpdude

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.

Outcomes