1 - DP_AddDays

Description :

  Add Days to DataTime.

Function Group :

  Add

Input :

  <DateTime1> , <Integer>

Output :

  <DataTime>

Example :

  DP_AddDays(#2024-08-22 10:23:40#, 1)  >   #2024-08-23 10:23:40#

Notes :

  Versions: Client function, Server function, Warped Function

2 - DP_AddHours

Description :

  Add Hours to DataTime.

Function Group :

  Add

Input :

  <DateTime1> , <Integer>

Output :

  <DataTime>

Example :

  DP_AddHours(#2024-08-22 10:23:40#, 1)  >  #2024-08-22 11:23:40#

Notes :

  Versions: Client function, Server function, Warped Function

3 - DP_AddMinutes

Description :

  Add Minutes to DateTime.

Function Group :

  Add

Input :

  <DateTime1> , <Integer>

Output :

  <DataTime>

Example :

  DP_AddMinutes(#2024-08-22 10:23:40#, 1)  >  #2024-08-22 10:24:40#

Notes :

  Versions: Client function, Server function, Warped Function

4 - DP_AddMonths

Description :

  Add Months to DateTime.

Function Group :

  Add

Input :

  <DateTime1> , <Integer>

Output :

  <DataTime>

Example :

  DP_AddMonths(#2024-08-22 10:23:40#, 1)  >  #2024-09-22 10:23:40#

Notes :

  Versions: Client function, Server function, Warped Function

5 - DP_AddQuarters

Description :

  Add Quarters to DataTime.

Function Group :

  Add

Input :

  <DateTime1> , <Integer>

Output :

  <DataTime>

Example :

  DP_AddQuarters(#2024-08-22 10:23:40#, 1)  >  #2024-11-22 10:23:40#

Notes :

  Versions: Client function, Server function,

6 - DP_AddSeconds

Description :

  Add Seconds to DateTime

Function Group :

  Add

Input :

  <DateTime1> , <Integer>

Output :

  <DataTime>

Example :

  DP_AddSeconds(#2024-08-22 10:23:40#, 12)  >  #2024-10-22 10:23:52#

Notes :

  Versions: Client function, Server function, Warped Function

7 - DP_AddSemesters

Description :

  Add Semesters to DataTime

Function Group :

  Add

Input :

  <DateTime1> , <Integer>

Output :

  <DataTime>

Example :

  DP_AddSemester(#2024-08-22 10:23:40#, 1)  >  #2025-04-22 10:23:40#

Notes :

  Versions: Client function, Server function,

8 - DP_AddWeeks

Description :

  Add Weeks to DateTime

Function Group :

  Add

Input :

  <DataTime1> , <Integer>

Output :

  <DataTime>

Example :

  DP_AddWeeks(#2024-08-22 10:23:40#, 1)  >  #2024-08-27 10:23:40#

Notes :

  Versions: Client function, Server function,

9 - DP_AddWorkdays

Description :

  DateTime after n works days.

Workdays > Monday to Friday.

Holidays not consider

Function Group :

  Add

Input :

  <DateTime1> , <Integer>

Output :

  <DateTime>

Example :

  DP_AddWorkdays(#2024-08-22 10:23:40#, 1)  >  #2024-08-23 10:23:40#

DP_AddWorkdays(#2024-08-22 10:23:40#, 2)  >  #2024-08-26 10:23:40#

Notes :

  Versions: Client function, Server function,

10 - DP_AddYears

Description :

  Add Years to DataTime

Function Group :

  Add

Input :

  <DateTime1> , <Integer>

Output :

  <DataTime>

Example :

  DP_AddYears(#2024-08-22 10:23:40#, 1)  >  #2025-08-22 10:23:40#

Notes :

  Versions: Client function, Server function, Warped Function

11 - DP_BuildDateTime

Description :

  Concatenated Date and Time parts.

Function Group :

  Build

Input :

  <Date> , <Time>

Output :

  <DateTime>

Example :

  DP_BuildDateTime(#2024-04-12#,#10:29:15#)  >  #2024-04-12 10:29:15#

Notes :

  Versions: Client function, Server function, Warped Function

12 - DP_CurrDate

Description :

  Output Current Date.

Function Group :

  Build

Input :

Output :

  <Date>

Example :

  DP_CurrDate()  >  #2024-08-12#

Notes :

  Versions: Client function, Server function, Warped Function

13 - DP_CurrDateTime

Description :

  Output Current DateTime.

Function Group :

  Build

Input :

Output :

  <DateTime>

Example :

  DP_CurrDateTime()  >  #2024-08-12 10:23:20#

Notes :

  Versions: Client function, Server function, Warped Function

14 - DP_CurrTime

Description :

  Output Current Time.

Function Group :

  Build

Input :

Output :

  <Time>

Example :

  DP_CurrTime()  >  #10:23:20#

Notes :

  Versions: Client function, Server function, Warped Function

15 - DP_DateTimeCeiling

Description :

  Output the insert Date with time 23:59:59

Function Group :

  Build

Input :

  <Date1>

Output :

  <DateTime>

Example :

  DP_DateTimeCeiling(#2024-04-02#) > #2024-04-02 23:59:59#

Notes :

  Versions: Client function, Server function,

16 - DP_DateTimeFloor

Description :

  Output the insert Date with time 00:00:00

Function Group :

  Build

Input :

  <Date1>

Output :

  <DateTime>

Example :

  DP_DateTimeFloor(#2024-04-02#) > #2024-04-02 00:00:00#

Notes :

  Versions: Client function, Server function,

17 - DP_NewDate

Description :

  Output a Date with input of y, m, d

Function Group :

  Build

Input :

  <Integers> , <3>

Output :

  <Date>

Example :

  DP_NewDate(2024,02,27)  >  #2024-02-27 00:00:00#

Notes :

  Versions: Client function, Server function, Warped Function

18 - DP_NewDateTime

Description :

  Output a Date with input of y, m, d, h, m, s

Function Group :

  Build

Input :

  <Integers> , <6>

Output :

  <DateTime>

Example :

  DP_NewDateTime(2024,3,23,22,20,3)  >  #2024-03-23 22:20:03#

Notes :

  Versions: Client function, Server function, Warped Function

19 - DP_NewTime

Description :

  Output a time with input h,m,s

Function Group :

  Build

Input :

  <Integers> , <3>

Output :

  <Time>

Example :

  DP_NewTime(22,20,3)  >  #22:20:03#

Notes :

  Versions: Client function, Server function,

20 - DP_1JanWeekDay

Description :

  Output the ordinary day of week [1-7] of 1st day of Year.

ISO Version. 1:Monday – 7:Sunday

Function Group :

  Calculate

Input :

  <Year (Int)>

Output :

  <Integer>

Example :

  DP_1JanWeekDay(2024)  > 1

DP_1JanWeekDay()  > 1

Notes :

  Versions: Client function, Server function,

21 - DP_BeginOfSemester

Description :

  Output the date of First day of a Semester.

Function Group :

  Calculate

Input :

  <Semester (Int)> , <Year>

Output :

  <DateTime>

Example :

  DP_BeginOfSemester(2,2024)  > #2024-07-01 00:00:00#

DP_BeginOfSemester(2)  > #2024-07-01 00:00:00#

Notes :

  Year not mandatory (default: Present Year)

  Versions: Client function, Server function,

22 - DP_BeginOfTrimester

Description :

  Output the date of First day of a Trimester.

Function Group :

  Calculate

Input :

  <Trimester (Int)> , <Year>

Output :

  <DateTime>

Example :

  DP_BeginOfTrimester(2,2024)  > #2024.04.01 00:00:00#

DP_BeginOfTrimester(2)  > #2024.04.01 00:00:00#

Notes :

  Year not mandatory (default: Present Year)

  Versions: Client function, Server function,

23 - DP_DayOfWeek

Description :

  Output the ordinary day of week [1-7].

ISO Version. 1:Monday – 7:Sunday

Function Group :

  Calculate

Input :

  <Date1>

Output :

  <Integer>

Example :

  DP_DayOfWeek(#2024-03-30#)  > 6

Notes :

  ISO Version. 1:Monday – 7:Sunday

  Versions: Client function, Server function, Warped Function

24 - DP_DayOfYear

Description :

  Output the ordinary day of year [1-366].

Function Group :

  Calculate

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_DayOfYear(#2024-03-31#)  > 91

Notes :

  Versions: Client function, Server function,

25 - DP_DaysToYearEnd

Description :

  Output the number of days to end of Year 365-0.

Function Group :

  Calculate

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_DaysToYearEnd(#2024-03-31#)  > 275

Notes :

  Versions: Client function, Server function,

26 - DP_EasterDay

Description :

  Calculate to easter sunday.

Function Group :

  Calculate

Input :

  <Year (Int)>

Output :

  <Date>

Example :

  DP_EasterDay(2004)  > #2024-03-31#

Notes :

  Versions: Client function, Server function,

27 - DP_EndOfMonth

Description :

  Output the last day of a month, if not input the year the action actual year

Function Group :

  Calculate

Input :

  <Month (Int)> , <Year (Int)>

Output :

  <Integer>

Example :

  DP_EndOfMonth(3,2024)  >  #2024-03-31#

Notes :

  Versions: Client function, Server function,

28 - DP_EndOfSemester

Description :

  Output the date of Last day of a Semester.

Function Group :

  Calculate

Input :

  <Semester (Int)> , <Year>

Output :

  <DateTime>

Example :

  DP_EndOfSemester(1,2024)  >  #2024-06-30#

Notes :

  Versions: Client function, Server function,

29 - DP_EndOfTrimester

Description :

  Output the date of Last day of a Trimester.

Function Group :

  Calculate

Input :

  <Trimester (Int)> , <Year>

Output :

  <DateTime>

Example :

  DP_EndOfTrimester(1,2024)  >  #2024-03-31#

Notes :

  Versions: Client function, Server function,

30 - DP_MaxDate

Description :

  Output the largest date.

Function Group :

  Calculate

Input :

  <Date1> , <Date2>

Output :

  <Date>

Example :

  DP_MaxDate(#2024-04-02#,#2024-04-10#) > #2024-04-10#

Notes :

  Versions: Client function, Server function,

31 - DP_MaxDateTime

Description :

  Output the largest date of two DateTime.

Function Group :

  Calculate

Input :

  <DateTime1> , <DateTime2>

Output :

  <DateTime>

Example :

  DP_MaxDateTime(#2024-02-27 00:00:00#,#2024-04-28 00:23:00#)  > #2024-04-28 00:23:00#

Notes :

  Versions: Client function, Server function,

32 - DP_MinDate

Description :

  Output the smallest date.

Function Group :

  Calculate

Input :

  <Date1> , <Date2>

Output :

  <Date>

Example :

  DP_MaxDate(#2024-04-02#,#2024-04-10#) > #2024-04-02#

Notes :

  Versions: Client function, Server function,

33 - DP_MinDateTime

Description :

  Output the smallest date of two DateTime.

Function Group :

  Calculate

Input :

  <DateTime1> , <DateTime2>

Output :

  <DateTime>

Example :

  DP_MinDateTime(#2024-02-27 00:00:00#,#2024-04-28 00:23:00#)  > #2024-02-28 00:00:00#

Notes :

  Versions: Client function, Server function,

34 - DP_NextWorkDay

Description :

  Output the next workday DateTime. Holidays not consider.

Function Group :

  Calculate

Input :

  <DateTime1>

Output :

  <DateTime>

Example :

  DP_NextWorkDay(#2024-04-02 23:10:05#)  >  #2024-04-03 23:10:05#

Notes :

  Versions: Client function, Server function,

35 - DP_OrdWeekday

Description :

  Output the Date of a selected weekday

Function Group :

  Calculate

Input :

  <Pos (int)> , <Weekday (int)>

Output :

  <Date>

Example :

  DP_OrdWeekday(2,2,5,2024) > #2004-05-14#

DP_OrdWeekday(-1,2,5,2024) > #2004-05-28#

DP_OrdWeekday(0,2,5,2024) > #1900-01-01#

Notes :

  Pos = -1 for last week of month

  Versions: Client function, Server function,

36 - DP_DiffDays

Description :

  Output the number of days between two DateTimes.

Function Group :

  Diff

Input :

  <DateTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffDays(#2024-02-27 00:00:00#,#2024-04-28 00:00:00#)  > 38

Notes :

  Versions: Client function, Server function, Warped Function

37 - DP_DiffHours

Description :

  Output the number of hours between two DateTimes.

Function Group :

  Diff

Input :

  <DateTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffHours(#2024-02-27 00:00:00#,#2024-04-28 00:00:00#)  > 912

DP_DiffHours(#2024-02-27 00:00:00#,#2024-04-28 03:00:00#)  > 915

Notes :

  Versions: Client function, Server function, Warped Function

38 - DP_DiffMilliSeconds

Description :

  Output the number of milliseconds between two unix date.

Difference between one value with actual unix time.

Function Group :

  Diff

Input :

  <LongInteger>

Output :

  <LongInteger>

Example :

  DP_DiffMilliSeconds(1729785716168) > 23000

Notes :

  Returns the difference of milliseconds between two date times with milliseconds.

  Versions: Client function, ,

39 - DP_DiffMinutes

Description :

  Output the number of minutes between two DateTimes.

Function Group :

  Diff

Input :

  <DateTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffMinutes(#2024-02-27 00:00:00#,#2024-02-28 00:00:00#)  > 1140

Notes :

  Versions: Client function, Server function, Warped Function

40 - DP_DiffMonths

Description :

  Output the number of months between two DateTimes.

Function Group :

  Diff

Input :

  <DateTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffMonths(#2024-02-27 00:00:00#,#2024-03-28 00:00:00#)  > 1

Notes :

  Versions: Client function, Server function,

41 - DP_DiffQuarters

Description :

  Output the number of quarter between two DateTimes.

Function Group :

  Diff

Input :

  <DateTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffQuarters(#2024-01-27 00:00:00#,#2024-04-28 00:00:00#)  > 1

Notes :

  Versions: Client function, Server function,

42 - DP_DiffSeconds

Description :

  Output the number of seconds between two DateTimes.

Function Group :

  Diff

Input :

  <DateTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffSeconds(#2024-02-27 00:00:00#,#2024-02-28 00:00:00#)  > 68400

Notes :

  Versions: Client function, Server function, Warped Function

43 - DP_DiffSemesters

Description :

  Output the number of semesters between two DateTimes.

Function Group :

  Diff

Input :

  <DateTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffSemesters(#2024-01-27 00:00:00#,#2024-04-28 00:00:00#)  > 0

Notes :

  Versions: Client function, Server function,

44 - DP_DiffTrimesters

Description :

  Output the number of trimesters between two DateTimes.

Function Group :

  Diff

Input :

  <DataTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffTrimesters(#2024-01-27 00:00:00#,#2024-04-28 00:00:00#)  > 1

Notes :

  Versions: Client function, Server function,

45 - DP_DiffWeeks

Description :

  Output the number of full weeks between two DateTimes.

Function Group :

  Diff

Input :

  <DateTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffWeeks(#2024-02-27 00:00:00#,#2024-03-28 00:00:00#)  > 4

Notes :

  Versions: Client function, Server function,

46 - DP_DiffWorkDays

Description :

  Output the number of workdays between two DateTimes.

Function Group :

  Diff

Input :

  <DateTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffWorkDays(#2024-02-27 00:00:00#,#2024-04-28 00:00:00#)  > 32

Notes :

  Not considers holidays

  Versions: Client function, Server function,

47 - DP_DiffYears

Description :

  Output the number of years between two DateTimes.

Function Group :

  Diff

Input :

  <DateTime1> , <DateTime2>

Output :

  <Integer>

Example :

  DP_DiffYears(#2024-02-27 00:00:00#,#2024-04-28 00:00:00#)  > 0

Notes :

  Versions: Client function, Server function,

48 - DP_GetCentury

Description :

  Output the century of input DateTime.

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetDate(#2024-04-02 23:10:05#)  >  #2024-04-02#

Notes :

  Versions: Client function, Server function,

49 - DP_GetDate

Description :

  Output the Date part of a DataTime.

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Date>

Example :

  DP_GetCentury(#2024-04-02 23:10:05#)  > 22

Notes :

  Versions: Client function, Server function, Warped Function

50 - DP_GetDay

Description :

  Output the day part of DateTime.

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetDay(#2024-04-02 23:10:05#)  > 2

Notes :

  Versions: Client function, Server function, Warped Function

51 - DP_GetHour

Description :

  Output the hours part of DateTime.

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetHour(#2024-04-02 23:10:05#)  > 23

Notes :

  Versions: Client function, Server function, Warped Function

52 - DP_GetMinute

Description :

  Output the minutes part of DateTime.

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetMinute(#2024-04-02 23:10:05#)  > 10

Notes :

  Versions: Client function, Server function, Warped Function

53 - DP_GetMonth

Description :

  Output the month part of DateTime.

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetMonth(#2024-04-02 23:10:05#)  > 4

Notes :

  Versions: Client function, Server function, Warped Function

54 - DP_GetQuarter

Description :

  Output the quarter of a DateTime.

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetQuarter(#2024-04-02 23:10:05#)  > 2

Notes :

  Versions: Client function, Server function,

55 - DP_GetSecond

Description :

  Output the seconds part of DateTime.

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetSecond(#2024-04-02 23:10:05#)  > 5

Notes :

  Versions: Client function, Server function, Warped Function

56 - DP_GetSemester

Description :

  Output the semester of a DateTime

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetSemester(#2024-04-02 23:10:05#)  > 1

Notes :

  Versions: Client function, Server function,

57 - DP_GetTime

Description :

  Output the Time part of a DataTime.

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Time>

Example :

  DP_GetTime(#2024-04-02 23:10:05#)  >  #23:10:05#

Notes :

  Versions: Client function, Server function, Warped Function

58 - DP_GetTrimester

Description :

  Output the trimester of a DateTime.

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetTrimester(#2024-04-02 23:10:05#)  > 2

Notes :

  Versions: Client function, Server function,

59 - DP_GetUnixMilliSeconds

Description :

  Output current date time  (UTC) with UNIX milliseconds

Since Jan 1, 1970 00:00:00 UTC

Function Group :

  Get

Input :

Output :

  <LongInteger>

Example :

  DP_GetUnixMilliSeconds() > 1729785716168

Notes :

  JavaScript Returns current date time with milliseconds with milliseconds on UTC

  Versions: Client function, ,

60 - DP_GetUnixSeconds

Description :

  Output current date time  (UTC) with UNIX seconds

Since Jan 1, 1970 00:00:00 UTC

Function Group :

  Get

Input :

Output :

  <LongInteger>

Example :

  DP_GetUnixSeconds() > 1729785716

Notes :

  JavaScript Returns current date time with seconds with seconds on UTC

  Versions: Client function, ,

61 - DP_GetWeek

Description :

  Output the ISO Week Number [1-53].

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetWeek(#2024-04-02 23:10:05#)  > 14

Notes :

  Versions: Client function, Server function,

62 - DP_GetYear

Description :

  Output the year part of DateTime

Function Group :

  Get

Input :

  <DateTime1>

Output :

  <Integer>

Example :

  DP_GetYear(#2024-04-02 23:10:05#)  > 2024

Notes :

  Versions: Client function, Server function, Warped Function

63 - DP_IsDate

Description :

  Check if Date format

Function Group :

  Logical

Input :

  <Date (Text)>

Output :

  <Logic>

Example :

  DP_IsDate("2024-04-02") > True

Notes :

  Versions: Client function, Server function, Warped Function

64 - DP_IsDateTime

Description :

  Check if DateTime format

Function Group :

  Logical

Input :

  <DateTime (Text)>

Output :

  <Logic>

Example :

  DP_IsDateTime("2024-04-02 22:12:00") > True

Notes :

  Versions: Client function, Server function, Warped Function

65 - DP_IsLeapYear

Description :

  Checks if the year is a Leap Year

Function Group :

  Logical

Input :

  <Year (Int)>

Output :

  <Logic>

Example :

  DP_IsLeapYear(2024)  > True

Notes :

  Versions: Client function, Server function,

66 - DP_IsTime

Description :

  Check if Time format

Function Group :

  Logical

Input :

  <Time (Text)>

Output :

  <Logic>

Example :

  DP_IsTime("22:12:00") > True

Notes :

  Versions: Client function, Server function, Warped Function

67 - DP_IsWorkDay

Description :

  Checks if the day is a workday

Function Group :

  Logical

Input :

  <DateTime1>

Output :

  <Logic>

Example :

  DP_IsWorkDay(#2024-02-27 00:00:00#)  > True

Notes :

  Versions: Client function, Server function,