gCalender ( vPara )

genius Kalender (ala ABAS)

Average rating: 4.3 (27 votes) Log in to vote

Matijas Federspiel
ComZuWeb-Datasystem
http://www.comzuweb-datasystem.de/

Sample input:

gCalender (".")
gCalender("+28")
gCalender ("-2")

Sample output:

08/05/2014
05/06/2014
06/05/2014

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

/* 2014-05-08 Matijas Federspiel: genius Calender (ala ABAS) */
/* gCalender (".")   = Today (08/05/2014)                    */
/* gCalender ("+28") = 05/06/2014                            */
/* gCalender ("-2")  = 06/05/2014                            */


Let([

vPara=Left(vWert;1);
vDay=Middle(vWert;2;999);

vPara=Case (
vPara=".";Get ( CurrentDate );
vPara="+";Get ( CurrentDate )+vDay;
vPara="-";Get ( CurrentDate )-vDay)

];
vPara

)

Comments

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

gCalender ( vPara )

Comments

Support this website.

Support this website.