Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

CF.TurnIt ( ValueToTurn ; YearLength )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 4.6  (29 votes)
  Discuss this Custom Function

Thomas Hellwig, DELASOCIAL
http://www.delasocial.com

This function turns a date or a timestamp or turns back a turned date or a turned timestamp.

Sample Input:
CF.TurnIt ( "30.07.2014 21:29:55" ; 2 )
Sample Output:
140730_212955


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

This function inverts a date or a timestamp or inverts back an inverted date or an inverted timestamp. It also compresses a time of day (clock time). A date or a timestamp wich is inverted, results in a textstring that for example can be used to term folders or files. Subsequently you can sort your folders or files easily by (the inverted) date or timestamp.

Comment:
Time in a timestamp will not be inverted in order to maintain the possibility of sorting (folders or files) by date and time correctly. Timestamp format is "DD.MM.YYYY hh:mm:ss" (24-hour count notification). The delimiter between date and time of a turned timestamp is "_".

Operation codes are: (In version 1.0 there was a second parameter called "OperationCode". I removed that parameter and adapted the function to identify the ValueToTurn string by itself. So now the CF reads the ValueToTurn parameter and inverts the value as you desire.)

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

This is my Custom Function and I want to edit it

Discuss:

I do get constant errors, which seem to be some comments passing like data


It occurs at line 42

with the string SetzeVars

I do get the message "This function can not be found"

Could you post agian a corrected version... I would be helped.

thnaks



//################################################ ############################################

SetzeVars ( //--- Top
[
VTT = ValueToTurn ;
ERR = "Wrong Value" ;
R6TTS = ZeichenRechts ( VTT ; 6 ) ;
CT = Falls ( R6TTS < 240000 UND ZeichenRechts ( R6TTS ; 4 ) < 6000 UND ZeichenRechts ( R6TTS ; 2 ) < 60 ; 1 ; 0 ) ;
OperationCode = Falls ( LiesAlsDatum ( VTT ) = VTT ; 1 ; Länge ( VTT ) = 8 UND LiesAlsZahl ( VTT ) = VTT ; 2 ; LiesAlsZeitstempel ( VTT ) = VTT ; 3 ; Länge ( VTT ) = 15 UND LiesAlsZahl ( ZeichenLinks ( VTT ; 8 ) ) = ZeichenLinks ( VTT ; 8 ) UND CT = 1 UND MusterAnzahl ( VTT ; "_" ) = 1 ; 4 ; 0 )
] ;

Tjebbe van Tijen, Amsterdam
June 23, 2015 10:16am

Hello!
Look at the head info:
___ Code language: German
___ FMP version: 12

The function name "SetzeVars" (http://www.filemaker.com/de/help/html/func_ref3.33.15.html) is correct, but in FM 13 it is "SetzeVar" (http://www.filemaker.com/help/13/fmp/de/html/func_ref3.33.16.html).

Thomas Hellwig, Hamburg
June 23, 2015 10:34am

Thank you for quick reactions... sadly I am still using Filemaker Pro 11 (Advanced) would it work (with some adaption in that application at all?

schöne Grüsse

tjebbe

Tjebbe van Tijen, Amsterdam
June 23, 2015 12:22pm

I think it will work with FM 11. You can chance the language of FM with a tool called Language Switcher (Mac). The code will be automatically translated.

Hope that it helps you!

Thomas Hellwig, Hamburg
June 23, 2015 12:38pm

New version uploaded!

Thomas Hellwig, Hamburg
June 23, 2015 12:49pm

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 4 + 2 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions