Solved

Insert a date in a table in an ASP page

Posted on 2014-02-12
5
439 Views
Last Modified: 2014-02-17
I have a web page that is in asp format. It is a simple list  that the names are linked to some folders on a file share. what I would like to do is add another column to the table so out beside each folder name I could insert a date of when the documents need to be reviewed within that folder and a checkbox so when the review happens the owner could click the review box and it would reset the dat out to the next interval so for instance if the date is today and they click the box it will change to be Feb. 12, 2016 is the review frequency is 2 years. is this possible.  I guess I also need to ensure only the person i assign could clikc the button but I think I can handle that by pulling the AD information when they open the webpage but I would only want the checkbox to be visible if it was the person assigned. so for instance we use numbers to identify users here so I only want user 4321 to see the checkbox.
0
Comment
Question by:jlcannon
  • 3
  • 2
5 Comments
 
LVL 52

Expert Comment

by:Scott Fell, EE MVE
ID: 39854988
I'm not sure what your real question is.  Perhaps post the code you are using and explain where you are stuck.

You can add dates with dateAdd http://www.w3schools.com/vbscript/func_dateadd.asp

theDate = "2/12/2014"
newDAte=dateadd("yyyy",2,theDate) ' = 2/12/2016

Open in new window


LoggedInUser="1234"
theFile =rs("Files") '  /folder/folder/file.pdf
FileOnwer=rs("FileOwner") ' 1234
if cstr(trim(LoggedInUser))=cstr(trim(FileOwner)) then
   response.write theFile& " <input type=""checkbox"">Checkox Info"
end if

Open in new window

0
 

Author Comment

by:jlcannon
ID: 39857324
I dont have any code yet but what I know how to do is validate who is on the website by using the active directory look-up and what I am needing to know is if it is possible to based on who is on the website, make a checkbox show or be grayed out and 2 insert a date of 1 year from the date I post the link to the paper and upon that one year if they do not go in and check that it has been reviewed the date will turn red or something similar but if they do go in and review the paper and check the checkbox it will automatically make the date 1 year from the date they check the box.
0
 
LVL 52

Accepted Solution

by:
Scott Fell,  EE MVE earned 500 total points
ID: 39857454
>is possible to based on who is on the website, make a checkbox show or be grayed out
Yes, I have the code above and will paste it below.  

You will check who the logged in user is by assigning a variable LoggedInUser.
Below is an option to test if the logged in owner matches something.  In this case a recordset with field name FileOwner.
LoggedInUser="1234"
theFile =rs("Files") '  /folder/folder/file.pdf
FileOnwer=rs("FileOwner") ' 1234
if cstr(trim(LoggedInUser))=cstr(trim(FileOwner)) then
   response.write theFile& " <input type=""checkbox"">Checkox Info"
end if

Open in new window

If you have a list of files you could test that as well.  

An html checkbox "greyed out" is disabled. It looks like this
<input type="checkbox" value="1234" disabled>1234

Open in new window

In asp
response.write "<input type=""checkbox"" value=""1234"" disabled>1234"

Open in new window

or
<input type="checkbox" value="1234" <% if something="no" then response.write " disabled" end if%>>1234

Open in new window


>automatically make the date 1 year from the date they check
This is dateAdd.  "yyyy" means ad a year, the 1 is the amount of time and the last part is the starting date.  In this case, a variable.
theDate = "2/12/2014"
newDAte=dateadd("yyyy",1,theDate) ' = 2/12/2016

Open in new window

0
 

Author Comment

by:jlcannon
ID: 39859146
Thank you and I will try this once I am back infront of my development computer which will be monday.
0
 

Author Closing Comment

by:jlcannon
ID: 39864839
This is what I was looking for, thank you.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
HTML5 Looping table certain Cell 11 42
Fulfillment API php code sample 1 41
Jquery 10 20
Background video not displaying in Internet Explorer. 3 26
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question