https://pranke.com/hilfe/ 2026-04-17T14:09:08+00:00 https://pranke.com/hilfe/ https://pranke.com/hilfe/lib/exe/fetch.php?media=favicon.ico text/html 2024-10-16T18:38:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:actualdatetime&rev=1729096690&do=diff ActualDateTime The function ActualDateTime (<DateTime-Format>) returns the current date and time in the local time zone. If no parameter has been specified, it is formatted as year, month, day, hour, minute and second („yyyyyMMddTHHmm“). Syntax: text/html 2024-10-16T18:39:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:actualutcdatetime&rev=1729096769&do=diff ActualUtcDateTime The function ActualUtcDateTime(<DateTime-Format>) returns the current UTC date and time. If no parameter has been specified, it is formatted as year, month, day, hour, minute and second (“yyyyyMMddTHHmm”). Syntax: ActualUtcDateTime() text/html 2024-06-06T14:44:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:adddate&rev=1717677870&do=diff AddDate The function AddDate() adds a period (d days - default -, m months or y years) to a date and returns it as a result. The date is returned as a character string in short date format in the language in which the server is configured. E.g. for fr-FR culture: dd/MM/yyyy, for nl-NL culture d-M-yyyy. text/html 2024-10-23T14:19:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:adddatetime&rev=1729685975&do=diff AddDateTime The AddDateTime() adds a period (h hours - default - or m minutes or s seconds) to a date and returns it as a result. Syntax: AddDateTime('Date', 'quantity', 'identifier') Beispiele: AddDateTime('2014-12-15 01:00:00', '10' ) return 2014-12-15 11:00:00 text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:comparedatetime&rev=1708413318&do=diff CompareDateTime The CompareDateTime()/ function compares two date values and returns a numeric value as a result. * for date 1 > date 2, the function returns 1 * for date 1 = date 2, the function returns 0 * for date 1 < date 2, the function returns text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:convertedatetimefromstring&rev=1708413318&do=diff ConvertDateTimeFromString The ConvertDateTimeFromString() function converts a date value formatted as string to a date value and returns it as string. The function expects at least one parameter and returns the date value as string. If a date value should be returned, the function text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:convertedifactdate&rev=1708413318&do=diff ConvertEdifactDate The ConvertEdifactDate() function converts a date value in string format (EDIFACT date value) to a formatted date value. The second parameter specifies the format of the EDIFACT date, i. e. 102, for the short date and 203 for the long date. text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:convertetodatetimefromstring&rev=1708413318&do=diff ConvertToDateTimeFromString The function ConvertToDateTimeFromString() works exactly like ConvertDateTimeFromString., only that a date value is returned. The function ConvertToDateTimeFromString() converts a date value formatted as a string into a date value. The formats to be recognized can be specified. text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:datediff&rev=1708413318&do=diff DateDiff The DateDiff function (<DateTime>, <DateTime>, <String>) returns the difference between two DateTimes as a number and rounds, if need to, to 2 decimal digits. The returned value is always positive. Possible values ​​for the “identifier text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:formatdatetime&rev=1708413318&do=diff FormatDateTime The function formats a date value in an EDIFACT compatible date format, a character string (string) is returned. Possible values ​​are: * 101: for the EDIFACT format yyMMdd * 102: for the EDIFACT format yyyyMMdd * 203: for the EDIFACT format yyyyMMddHHmm text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:getweeknumber&rev=1708413318&do=diff GetWeekNumber This function GetWeekNumber()/ accepts a date as string and returns the week number. See also WeekOfYear . Syntax: GetWeekNumber('Date') Beispiel: GetWeekNumber('23.08.2006') returns 34 GetWeekNumber('2022-04-12') liefert 16, which corresponds to the American calendar, on the other hand, delivered: text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:notemptydatetime&rev=1708413318&do=diff NotEmptyDateTime The function NotEmptyDateTime() checks whether a date variable contains an empty value or an invalid value. To do this, only one date variable must be specified as an argument. If their value is invalid, an empty string is returned as a result. This prevents further processing within a mapping rule set. The RuleSet is then simply skipped without an error being triggered. It is also possible to specify a minimum date value within the function by specifying a second argument, wit… text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:start&rev=1708413318&do=diff Date functions All functions related to date values. Topics datum index text/html 2024-02-20T08:15:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://pranke.com/hilfe/doku.php?id=en:transformation:mappings:funktionen:datum:weekofday&rev=1708413318&do=diff WeekOfYear The function WeekOfYear (<Date>,[Weekday rule],[First day of week]) returns the weekday on the given date. * Date: The date from which the day of the week is to be calculated. * weekday rule (Default value: first four days.): * 0 = First day