Discussion:
Webbot for date
(too old to reply)
Gyzmo
2007-07-11 20:54:04 UTC
Permalink
Since "webbot bot="Timestamp"" is from FP it really isn't legit in EW-is this
true? I have it on a couple pages and it still works.
If it does work can I use it or a similar method to change the text in the
html so that what ever day the reader opens the page it will read " As of
MM/DD/YYYY we have this many..." If not is there a way to do this?
Clark
2007-07-12 11:35:58 UTC
Permalink
" As of MM/DD/YYYY we have this many..." If not is there a way to do this?
I assume that you are drawing some value XX from a database to display after
"this many" and the MM/DD/YYYY is the date that XX was entered.

If so, then why not draw both XX and the date MM/DD/YYYY from the dataase
using one of the data display controls?

In Access, you can put in a field that automatically fills in the date when
a record is added by adding a field like "Timestamp", selecting its Format,
and for the Default value put: =date()
Gyzmo
2007-07-12 12:24:00 UTC
Permalink
Post by Clark
" As of MM/DD/YYYY we have this many..." If not is there a way to do this?
I assume that you are drawing some value XX from a database to display after
"this many" and the MM/DD/YYYY is the date that XX was entered.
If so, then why not draw both XX and the date MM/DD/YYYY from the dataase
using one of the data display controls?
In Access, you can put in a field that automatically fills in the date when
a record is added by adding a field like "Timestamp", selecting its Format,
and for the Default value put: =date()
Thanks Clark, but that will not do it. Look at the page
http://germanfiredept.org/Runs/runs.htm
and then you will see that I want to change the top date when vere the
viewer looks at the page and no data has been added for that day. It now is
changed each time there is a new run. I am going to see if I can use
javascript to do it.
Clark
2007-07-12 18:04:52 UTC
Permalink
I thought you were displaying results from a database, but it looks like you
arent (It would be easy to do, -- )

Are you just looking for something such that where your page currently says
"As of July 11 6 runs" the "July 11" instead would automatically be
replace by the current date?
Post by Gyzmo
Post by Clark
" As of MM/DD/YYYY we have this many..." If not is there a way to do this?
I assume that you are drawing some value XX from a database to display after
"this many" and the MM/DD/YYYY is the date that XX was entered.
If so, then why not draw both XX and the date MM/DD/YYYY from the dataase
using one of the data display controls?
In Access, you can put in a field that automatically fills in the date when
a record is added by adding a field like "Timestamp", selecting its Format,
and for the Default value put: =date()
Thanks Clark, but that will not do it. Look at the page
http://germanfiredept.org/Runs/runs.htm
and then you will see that I want to change the top date when vere the
viewer looks at the page and no data has been added for that day. It now is
changed each time there is a new run. I am going to see if I can use
javascript to do it.
md Webs Unlimited
2007-07-12 12:24:58 UTC
Permalink
You could also so something like:

SELECT 'There are ' & Count(*) & ' JBP-05 orders as of ' & Date() AS Orders
FROM product_orders
WHERE (((product_orders.[sku])='JBP-05'));

Which produces: There are 4744 JBP-04 orders as of 7/12/2007
--
Mike - FrontPage MVP '97 - '02
Expression Tools & Addin
http://www.j-moves.com
http://www.panemanager.com
FrontPage Tools & Addin
http://www.jbots.com
E-Commerce
http://www.candypress.com
Post by Clark
" As of MM/DD/YYYY we have this many..." If not is there a way to do this?
I assume that you are drawing some value XX from a database to display
after "this many" and the MM/DD/YYYY is the date that XX was entered.
If so, then why not draw both XX and the date MM/DD/YYYY from the dataase
using one of the data display controls?
In Access, you can put in a field that automatically fills in the date
when a record is added by adding a field like "Timestamp", selecting its
Format, and for the Default value put: =date()
Cheryl D Wise
2007-07-13 00:26:01 UTC
Permalink
IF you mean a last updated date assuming you aren't using dynamically
generated pages the code snippet at
http://by-expression.com/tutorials/last-updated/index.aspx will return the
date the page was last modified. (Note the page at that url will always show
the current date since it has dynamically generated content.)
--
Cheryl D Wise

Introduction to Expression Web class starts July 8 http://starttoweb.com

MS MVP FrontPage
http://by-expression.com
Author: Foundations of Microsoft Expression Web: The Basics and Beyond
Post by Gyzmo
Since "webbot bot="Timestamp"" is from FP it really isn't legit in EW-is this
true? I have it on a couple pages and it still works.
If it does work can I use it or a similar method to change the text in the
html so that what ever day the reader opens the page it will read " As of
MM/DD/YYYY we have this many..." If not is there a way to do this?
Loading...