Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

CF.TurnIt ( ValueToTurn ; YearLength )

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

  Average rating: 4.5 (30 votes) Log in to vote

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

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

/* ___ Function name: CF.TurnIt ( ValueToTurn ; YearLength ) ___ Version: 1.3 --- November 20th 2014 ___ Code language: German ___ FMP version: 12 ___ March 14th 2014 ___ Author: Thomas Hellwig ___ Contact: grafzahl68@gmx.de Version info (1.3): Operation code 5 added, that assimilates the value "Time of day" for example like "14:47:59" or Get ( CurrentTime ) ). It gives back a compressed number (e.g. "144759"). Version info (v1.2): Various lengths of a turned year, two or four digits, added with a new parameter called "YearLength". Example: 24.09.2015 becomes "150924" instead of "20150924". 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. Parameters: (ValueToTurn) Possible values: Date ( e.g. "14.03.2014" or Get ( CurrentDate ) ) Turned Date ( e.g. "20140314" ) Timestamp ( e.g. "28.08.1749 19:11:56" or Get ( CurrentTimeStamp ) ) Turned Timestamp ( e.g. "17490828_191156" ) Time of day ( e. g. "14:21:59" or Get ( CurrentTime ) ) (YearLength) Possible values: Output examples: 2 Turned Date ( e.g. "140314" ) 4 Turned Timestamp ( e.g. "17490828_191156" ) 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.) 1 = Turn a Date 2 = Turn a turned Date 3 = Turn a Timestamp 4 = Turn a turned Timestamp 5 = Compresses a Time of day Examples: Input Output _________________________________________________________ "31.03.1889" "18890331" or "890331" "18890331" "31.03.1889" "21.02.1968 17:55:06" "19680221_175506" or "680221_175506" "19680221_175506" "21.02.1968 17:55:06" "07:13:00" "071300" So for example CF.TurnIt ( Get ( CurrentTimeStamp ) ; 4 ) results in a text string like this: "20140314_123251". In case the ValueToTurn string cannot be processed proberly due to incorrect syntax, the custom function will return "Wrong Value". */ //############################################################################################ SetzeVars ( //___ Top [ VTT = ValueToTurn ; YL = YearLength ; 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 ; LiesAlsZeit ( VTT ) = VTT UND Länge ( VTT ) < 9 ; 5 ; 0 ) ] ; Falls ( //--------------------------------------------------------------------------------------------------------- OperationCode = "1" ; //___ Turns a Date SetzeVars ( [ FD = LiesAlsDatum ( VTT ) ] ; ZeichenRechts ( "00" & Jahreszahl ( FD ) ; YL ) & ZeichenRechts ( "00" & MonatZahl ( FD ) ; 2 ) & ZeichenRechts ( "00" & KalendertagZahl ( FD ) ; 2 ) ) ; //___ End Vars //--------------------------------------------------------------------------------------------------------- //--------------------------------------------------------------------------------------------------------- OperationCode = "2" ; //___ Turns a turned Date SetzeVars ( [ RTD = ZeichenRechts ( VTT ; 2 ) & "." & ZeichenMitte ( VTT ; 5 ; 2 ) & "." & ZeichenLinks ( VTT ; 4 ) ] ; LiesAlsDatum ( RTD ) ) ; //___ End Vars //--------------------------------------------------------------------------------------------------------- //--------------------------------------------------------------------------------------------------------- OperationCode = "3" ; //___ Turns a Timestamp SetzeVars ( [ TS = LiesAlsZeitstempel ( VTT ) ] ; ZeichenRechts ( Jahreszahl ( TS ) ; YL ) & ZeichenRechts ( "00" & MonatZahl ( TS ) ; 2 ) & ZeichenRechts ( "00" & KalendertagZahl ( TS ) ; 2 ) & "_" & Austauschen ( LiesAlsZeit ( TS ) ; ":" ; "" ) ) ; //___ End Vars //--------------------------------------------------------------------------------------------------------- //--------------------------------------------------------------------------------------------------------- OperationCode = "4" ; //___ Turns a turned Timestamp SetzeVars ( [ D = ZeichenLinks ( VTT ; 8 ) ; T = ZeichenRechts ( VTT ; 6 ) ; RTS = ZeichenRechts ( D ; 2 ) & "." & ZeichenMitte ( D ; 5 ; 2 ) & "." & ZeichenLinks ( D ; 4 ) & " " & ZeichenLinks ( T ; 2 ) & ":" & ZeichenMitte ( T ; 3 ; 2 ) & ":" & ZeichenRechts ( T ; 2 ) ] ; LiesAlsZeitstempel ( RTS ) ) ; //___ End Vars //--------------------------------------------------------------------------------------------------------- //--------------------------------------------------------------------------------------------------------- OperationCode = "5" ; //___ Compresses a Clocktime SetzeVars ( [ CT = ZeichenLinks ( Austauschen ( VTT ; ":" ; "" ) & "00" ; 6 ) ] ; CT & "_" & VTT ) ; //___ End Vars //--------------------------------------------------------------------------------------------------------- ERR ) //___ End Falls ) //___ End Vars Top //__________________________________________________________________________________________________________________________ Click to copy

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.)

 

Comments

		Tjebbe van Tijen, Amsterdam Jun 23, 2015
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 ) ] ;

		Thomas Hellwig, Hamburg Jun 23, 2015
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).

		Tjebbe van Tijen, Amsterdam Jun 23, 2015
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

		Thomas Hellwig, Hamburg Jun 23, 2015
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 Jun 23, 2015
New version uploaded!

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: