AFC - Abacus Formula Compiler for Java

Date Functions In AFC

Date Functions

The supported date functions are shown by example below:

NOW
AB
2(now)=NOW()

TODAY
AB
4(today)=TODAY()

DATE
ABCDE
639447.0=DATE(C6,D6,E6)2007.012.031.0
722383.0...1961.04.012.0
82713.0...7.06.05.0
938356.0...2003.023.065.0
1039040.0...2008.0-10.0-73.0

TIME
ABCDE
120.08546296296296296=TIME(C12,D12,E12)2.03.04.0
130.7055439814814815...16.055.059.0
140.6800462962962961...39.078.076.0
150.9814814814814814...100.0-200.0-4000.0

SECOND
ABC
1745.0=SECOND(C17)0.5213541666666667
180.0...35222.5
1959.0...3653.999988425926
2059.0...3653.999994 (#0.000000)
210.0...3653.999995 (#0.000000)

MINUTE
ABC
2330.0=MINUTE(C23)0.5213541666666667
240.0...35222.5
2559.0...3653.999988425926
2659.0...3653.999994 (#0.000000)
270.0...3653.999995 (#0.000000)

HOUR
ABC
2912.0=HOUR(C29)0.5213541666666667
3012.0...35222.5
3123.0...3653.999988425926
3223.0...3653.999994 (#0.000000)
330.0...3653.999995 (#0.000000)

WEEKDAY
ABCD
357.0=WEEKDAY(C35)39452.0
361.0...39453.0
377.0=WEEKDAY(C37,D37)39452.01.0
381.0...39453.01.0
397.0...39453.02.0
401.0...39454.02.0
416.0...39453.03.0
420.0...39454.03.0
430.0...39454.03.0
44!FE...39454.04.0Excel says: #NUM!

DAY
ABC
461.0=DAY(C46)40179.0
476.0...35222.5
4831.0...3653.0

MONTH
ABC
501.0=MONTH(C50)40179.0
516.0...35222.5
5212.0...3653.0

YEAR
ABC
542010.0=YEAR(C54)40179.0
551996.0...35222.5
561909.0...3653.0

DAYS360
ABCDE
581095.0=DAYS360(C58,D58)35222.036332.0
593600.0...7305.99936342592610958.561805555555
60-331.0=DAYS360(C60,D60)39788.039452.0
61331.0=DAYS360(C61,D61)39452.039788.0
62180.0...34758.034942.0
63180.0...35124.035308.0
6460.0...35094.035155.0
6560.0...35095.035155.0
6460.0...35094.035155.0
67182.0=DAYS360(C67,D67,E67)34758.034942.0true
68180.0...34758.034942.0false
69181.0...35124.035308.0true
68180.0...34758.034942.0false