Change Time Stamp to Date

[kcep]

Hi Everyone,

How do I change this timestamp ...
2017-08-12 08:24:55 -0500

to this type of date format ...
08-12-2017

?

Thanks for your help. :-) 

 

[Lee Smith]

See if this works.

Let ( [
	ts = yourTimeStamp_Field ;
	m  = Middle ( ts ; 6 ; 2 ) ;
	d  = Middle (  ts ; 9 ; 2 ) ;
	yr = left ( ts ;  4 )
];
	m  & "-" & d & "-" &yr 
)

 

[kcep]

Lee ... You're Great :-) No problem for a FileMaker master like you! Thanks.

[Agnes Riley]

Lee's example is great for teaching you how to think and build a calculation.

If you don't want to do it yourself, Brian Dunning's site has a large number of custom functions that might have what you're looking for. http://www.briandunning.com/filemaker-custom-functions/ 

So in a case like this I'd search for timestamp and go through and see if there was one that accomplish what I need, so I don't have to write one from scratch.

I get it, some people like to write everything from scratch. I'm more a re-use type of person to save time.

[Lee Smith]

Hi Agnes,

You make a good point.

1 hour ago, Agnes Riley said:

I'm more a re-use type of person to save time.

Me to.

However, I did looked for this particular pattern and didn't spot one right away, so I just wrote it out.

[Agnes Riley]

Oh, I did not check whether this thing exists. I just wanted to ket them know about the resource.

[Lee Smith]

Hi Agnes,

I do that too. 

Lee