Re: WSS Functions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: MDS (mds_work_at_hotmail.com)
Date: 02/21/04 

Date: Fri, 20 Feb 2004 21:16:54 -0500

I'm not sure what your looking to do... but I wanted similar things and
instead used views... i.e. sort on date created in decending... kinda get
the same things just not exactly...

But... you can have excel do this... create the field that you want and just
leave it a single line... then use the save and link with excel option...
save the query it makes, record a macro that open the query, calcs between
now() and date created and puts the different in your field... make a
scheduled job to do it once a night... days only change once a day... and
blank values were created today...

-MDS

"Dustin Miller [MVP]" <dustin-s-p-a-m@sharepointexperts.com> wrote in
message news:u2KEpl#9DHA.1636@TK2MSFTNGP12.phx.gbl...
> There is no date math in SharePoint. Only date comparison, and in the
case
> of certain types of fields, simple date addition (today+5 days). Sorry!
>
> --
> Dustin Miller [MVP]
> SharePoint Experts http://www.sharepointexperts.com
> SharePoint University http://www.sharepointu.com
> SharePoint Bootcamp http://www.sharepointexperts.com/training.htm
> ______________________________________________________________________
> "Al" <anonymous@discussions.microsoft.com> wrote in message
> news:1366601c3f7e1$60ec3160$a301280a@phx.gbl...
> > Can someone tell me how to create a field in issues with
> > the following logic:
> >
> > =[Today]-[Created]
> >
> > It doesn't support Today and Me. I created today's date
> > and tried the something instead of Today. No result.
> >
> > All I am trying to find out is how many days old an issue
> > and output to the end users.
> >
>
>

Relevant Pages

  • Query Update from Access: Re Ordering Columns
    ... decending dates across the top.... ... As each new subsequent date arrives.. ... Am I missing something where I can have Excel import in the exact same ...
    (microsoft.public.excel.programming)
  • RE: Macro
    ... Then post the query results. ... My data is in an Excel file called ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ... VBA code in excel suddenly became un-compileable. ...
    (microsoft.public.excel.programming)
  • Re: Excel Calcs in Access
    ... show below looks to me like an Excel sheet with one column of ... "John Nurick" wrote: ... below is the result of the same query but 1 line above. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.modulesdaovba)
  • Re: Looking for Easiest Way to Create Report
    ... By recording Excel macros and editing them you may be able to get all this down to one button push in each application. ... run your query then that makes life very much easier than it would have been if you'd had to match values line by line. ... So, if you do go for the query and TransferSpreadsheet route, that leaves you with the problem of levering in the four header rows. ... My guess is that the simplest solution will be in Excel, if you're prepared to do the job in two stages: one which generates the spreadsheet from Access, and another which requires you to move to Excel to add the headers. ...
    (microsoft.public.access.gettingstarted)
  • Re: EXCEL Issue retriving data from SQL
    ... I got the same results, one row in analyzer, and two in EXCEL. ... ' Establecer el query o stored procedure a ejecutar ... Dim lngRenglon As Long ...
    (microsoft.public.excel.programming)