Re: Problem with calclated field(column) in castom list Formula error

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ben (vnbenvn_at_yahoo.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 08:40:28 +0700

You may have to change date format in Regional and Language Setting

"Zen I" <zenoniwanicki@yahoo.com> wrote in message
news:cbcc5k$fml$1@atlantis.news.tpi.pl...
> Hi everybody,
>
> I'm using Windows 2003 Standard edition(Polish language version) and WSS
> 2.0 (Polish language version).
>
>
>
> I've tried to build very simplistic custom list with where I've got 2
fields
>
> "Date1" (date Time type),
>
> "Date2" (date time type)
>
> And then I try to ad third field - calculated field named f.example
"Diff"
> (integer type)
>
> To fill this calculated field I've used this formula with DATEDIF function
>
> [=DATEDIF(Date1,Date2,"D")]
>
> And after I click ok , I'm getting an error saying that syntax is wrong
or
> I'm using unsupported function.
>
>
>
> Any suggestions why this formula is wrong (if it is wrong.??)
>
>
>
> Zeno
>
>

Relevant Pages

  • Re: Browse to link..
    ... wouldn't you put in the document name and use a calculated field to ... hyperlink from "format url. ... I'm new to WSS, so this might be easy for others? ... I'm configuring a list with columns that should be used for a FAQ ...
    (microsoft.public.sharepoint.windowsservices)
  • Calculated Field refreshes only on edit??
    ... I have a calculated field (based on a TODAY column that was then ... that shows different images depending ... Is this a caching issue or some other thing? ... WSS 2003. ...
    (microsoft.public.sharepoint.windowsservices)
  • Link to Outlook with non-default fields
    ... I am linking contacts on my WSS site back to Outlook and everything works ... WSS contact to specific fields in Outlook ... the default one cannot be calculated) it is a calculated field as follows: ...
    (microsoft.public.sharepoint.windowsservices)
  • Conditional Calculated Field in list
    ... I've created a calculated field before, ... based on the alpha value of another field... ... using the calcaulate field in WSS? ...
    (microsoft.public.sharepoint.windowsservices)