Convert Odd Timestamp to Date

[JTSmith]

I'm hoping someone can help me...  I'm trying to convert the following Timestamp to Date.  The timestamp format is: 2017-10-30T14:47:12-06:00 .  I've tried to simply use the Left function to make it 2017-10-30, but I still can't convert that to a regular date.  

Any advice?  Thank you!

[Lee Smith]

Hi JT,

Have you checked out the Custom Functions at http://www.briandunning.com/filemaker-custom-functions/recentlist.php I remember that there are several there that deal with TimeStamps.

Lee

[JTSmith]

Yes, couldn't find one that works with my format

[Lee Smith]

Hi JT

You could also use the Let Function, I like it because it is easier to read.

Let ( [
	~ts = yourTimeStampField
];
	Date ( Middle ( ~ts ; 6 ; 2 ) ; Middle ( ~ts ; 9 ; 2 ) ; Left ( ~ts ; 4 )
 ))

You can also just use the Date Function

Date ( 
Middle ( yourTSfield ; 6 ; 2 ) ; 
Middle ( yourTSfield ; 9 ; 2 ) ; 
Left ( yourTSfield ; 4 ) 
)

Be sure your Calculation result is a DATE.

BYW, this is the CF I was thinking of.

http://www.briandunning.com/cf/1526

Edited November 1, 2017 by Lee Smith
added the CF link and Date Function

[JTSmith]

Thanks Lee!  Super big help!