Thursday, January 25, 2007

Sharepoint DATE formula continued

With the following formula you can calculate how many days ago a date has expired:

=ALS(ISFOUT(DATEDIF(ALS(OC_Datum="";"1-1-3000";OC_Datum);VANDAAG;"d"));"NA";DATEDIF(OC_Datum;VANDAAG;"d"))

- The Dutch function DATUMVERSCHIL is not recognized by SharePoint. DATEDIF is.
- The words IFen IFERROR are not recognized, use the dutch notation.
- The test ALS(OC_Datum="";"1-1-3000";OC_Datum) is necessary to ascertain whether a date is filled or not.
If this is empty, a date far in the future is assumed, so not expired.
- If the date is in the future, the result is converted to NA. (or negative number of days) (may return empty("")

Tuesday, January 23, 2007

SharePoint TODAY field and calculated fields...

Today we tried to use de system TODAY field in a formula. We got an error stating that this was not allowed. As we assumed there must be a work around.

Voila look here

Friday, January 12, 2007

SMS Gateway

Via onze HTTP-API

Integreer onze SMS-gateway in uw eigen systeem. Onze HTTP-API is gebaseerd op communicatie met XML, een HTTP-API is zeer handig omdat het in elke taal makkelijk te integreren is en er geen additionele applicaties voor u als klant voor nodig zijn. Wij hebben al direct downloadbare voorbeelden in PHP, ASP, Perl, Java en Python klaar liggen.

LinkWithin

Related Posts with Thumbnails