FilenameFromTimestamp ( theTimestamp ; suffix )

Response to a request from DUBAU, who wanted to create a filename from a timestamp.

Be the first to rate this function Log in to vote

Tim Anderson - Show more from this author
Tim Anderson Group

Sample input:

FilenameFromTimestamp ( get(CurrentTimestamp) ; "fmp12" )

Sample output:

20190131082233.fmp12

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let( [
_theDate=GetAsDate( theTimeStamp);
_theTime=GetAsTime(theTimeStamp);
_theSuffix=Case(Left( suffix;1)="."; suffix; "." & suffix);
_year=Year(_thedate);
_monthnum=Right("0"& Month(_thedate);2) ;
_day=Right("0"& Day(_theDate);2) ;
_hour=Right("0"& Hour(_theTime);2) ;
_min=Right("0"& Minute(_theTime);2) ;
_sec=Right("0"& Seconds(_theTime);2) 
]
;
_year & _monthnum & _day & _hour & _min & _sec & _theSuffix
)

Response to a request from DUBAU, who wanted to create a filename from a timestamp. Sorry for lack of comments but should be very clear to follow

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

FilenameFromTimestamp ( theTimestamp ; suffix )

Comments

Support this website.

Support this website.