Re: Date question??

Tech-Archive recommends: Speed Up your PC by fixing your registry

kk,

Let me get this straight. I can renew for 6 more months from May 1st to
July 31st, but my start date will still be Jan 20th and my Expiration date
will still be July 31st, thus requiring me to renew AGAIN for 6 more months
after July 31st? Is there a charge to renew? If so, what company do you
work for. I'll be sure that I never require your services. It sounds like
you guys are ripping people off!!! :-D (or <vbg>)

Please provide more information. Is Start Date coming from a cell? Is
Renew Date coming from a cell? Are you trying to put Expiration Date in a
cell? Are you trying to create a UDF to return Expiration Date to a cell?
Are you trying to update values in current cells or are you adding rows to a
table with these new values? Please post the code you have so far.

How can that be written in vb code?

I don't know how that can be written in VBA until I know what you are trying
to do.

HTH,

Conan






"kk" <kk@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E8250DA1-3810-468B-BEAE-E9F50480A57B@xxxxxxxxxxxxxxxx
I shall try to explain!!!
I keep a record of certificate dates. These certificates are valid for six
month only and have to be renewed every time. The certificate end date
will
always be at the end of the sixth month, but the start can be at any time
at
the first month.
ie if I renewed on the 20th of Jan then the run out date will be 31 July.
Now to complicate things. I can renew a certificate within 3 month of its
expiry date the start date wil still be the same.
ie with the same example...had I renewed within 3 month prior to the end
of
Jan, the expiry date will be the same (31 july). I hope that makes sense!!
How can that be written in vb code?
--
kk


.

Relevant Pages

  • Re: Date question??
    ... We have to renew before the expiry ... Is Start Date coming from a cell? ... I keep a record of certificate dates. ...
    (microsoft.public.excel.misc)
  • Re: Renew a SSL certificate
    ... I don't want create a new certificate but renew the existent ... If you mean 'certificate' as a whole, this isn't possible, as the expiration ... with the same public key that has a new expiration date, that is possible, ...
    (Fedora)
  • Re: AP renewal question
    ... "The 30 day renewal window you used to get to renew an AP/PAP after ... expiration date to get the renewal rate. ...
    (rec.arts.disney.parks)
  • cant get new or renew certs from exchange only after root ca cert expired
    ... the Microsoft Exchange Key Management Server could not be processed. ... I checked this and the cert is fine and I even renewed ... Certificate Services could not process request 1148 due to an error: ... I was able to renew another CA from the main CA that the KMS talks to ...
    (microsoft.public.win2000.security)
  • Certificate Renewal questions
    ... I need some help in understanding the mechanics of certificate renewal. ... In the Certificates MMC console, when I right-click on a cert and go to All ... Request with same key ... Renew with same key ...
    (microsoft.public.platformsdk.security)