I really hate the "Me to's" but in this case it would help our image.
-----Original Message-----
From: Josh Hillman [SMTP:admin-maillist@talstar.com]
Sent: Tuesday, April 22, 1997 5:20 PM
To: emerald@emerald.iea.com
Subject: accounts expiring on weekends
This one'll sound a little strange, but here it goes anyway:
In some future release of Emerald, will there or could there be an option
for having an automatic extension of a couple days put on an MBR if the
current expiration date (or Expiration + (Extend or Limit)) = a weekend day
(Saturday or Sunday)?
Every once in while, someone's account will expire on a weekend while no
one's in the office and if they call to find out why they can't log on, it
might be a while before someone can take care of it (by extending their
account a couple days). If there were some way of "telling Emerald" to
extend the expiration 2 days if the current one were a Saturday/Sunday (or
possibly some other specified day, incase some other ISP has off durring
one of the weekdays), this might work.
Does SQL have any way of knowing what day of the week any particular date
is?
E.g. 4/22/97 --> Tues.
Any thoughts on this?
Josh Hillman
hillman@talstar.com
----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com
------ =_NextPart_000_01BC4F48.5B7E6160
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+Ii0WAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAwAEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAGVtZXJhbGRAZW1lcmFs
ZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABgAAABlbWVyYWxkQGVtZXJhbGQuaWVhLmNvbQADABUMAQAAAAMA/g8GAAAA
HgABMAEAAAAaAAAAJ2VtZXJhbGRAZW1lcmFsZC5pZWEuY29tJwAAAAIBCzABAAAAHQAAAFNNVFA6
RU1FUkFMREBFTUVSQUxELklFQS5DT00AAAAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAAGAAAAGVt
ZXJhbGRAZW1lcmFsZC5pZWEuY29tAAIB918BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAA
AGVtZXJhbGRAZW1lcmFsZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAA
AwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAALpXwEEgAEAIgAAAFJFOiBhY2NvdW50cyBl
eHBpcmluZyBvbiB3ZWVrZW5kcwBKDAEFgAMADgAAAM0HBAAWABIACQArAAIANgEBIIADAA4AAADN
BwQAFgASAAgAKQACADMBAQmAAQAhAAAANUE4MkVERjIwNkJCRDAxMUJCMUMwMEEwQzkwNjJFMkYA
OwcBA5AGAJQHAAAhAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADAC4AAAAAAAMA
NgAAAAAAQAA5AICVtOFpT7wBHgBwAAEAAAAiAAAAUkU6IGFjY291bnRzIGV4cGlyaW5nIG9uIHdl
ZWtlbmRzAAAAAgFxAAEAAAAWAAAAAbxPaeFX8u2CW7sGEdC7HACgyQYuLwAAHgAeDAEAAAAFAAAA
U01UUAAAAAAeAB8MAQAAABAAAABlbWlsbGVyQGRlbC5uZXQAAwAGEIfYlzYDAAcQLQQAAB4ACBAB
AAAAZQAAAElSRUFMTFlIQVRFVEhFIk1FVE9TIkJVVElOVEhJU0NBU0VJVFdPVUxESEVMUE9VUklN
QUdFLS0tLS1PUklHSU5BTE1FU1NBR0UtLS0tLUZST006Sk9TSEhJTExNQU5TTVRQOkEAAAAAAgEJ
EAEAAAB0BAAAcAQAABIHAABMWkZ1poDBEncACgEDAfcgAqQD4wIAY4JoCsBzZXQwIAcThwKDAFAO
9nBycTIP9iZ9CoAIyCA7CW8yNWY1AoAKgXVjAFALA2MDAEELYG5nMTAzMzECsSBJIAlwB0BseYIg
D4B0ZSB0aBbQBCJNFtFvJ3MiIDxidQVAC4AW4QQAIGMuYQ+wGAAFQHcIYGxk4RaQZWxwIAhhGAAA
wHhnZS4KogqECoQLMGx4aTM2AUAVEAFAEUBvCRbAY3QQhDE2IC31HSJPBRBnC4AHQAXQB5D+cxoh
HSMaZhw0HAELExw2YGktMTQ0AUAbgDEcODABQAzQIMNiIEYVA2E6DINiD+BKb3MoaCBIAxBsA4Jb
U4BNVFA6YWRtC4BOLQDAI0EEAHRAAZBsyyTQCsAuBaBtXRplIfAXBmACMCJXVApQc2RhnHksD/AR
QAMRMjInkIAxOTk3IDU6AdBIIFBNJcdUbyJXZaUHgHIHQGRAKlUuCJDGYSVyJch1YmocYSJXGwDQ
BaB1AjAEIGV4cF5pBRAVcBmwA6B3CeBr/QnwZA9AHt8f6RuEC7YacyZUGFICIGUnFmAgc7MtgRlQ
YSAbgAJAbBbQ9yTQKoAVcGUnkBfSFwAJcJkY0mdvB5EAcHl3J3A7IlAaeUkDoDLgB4AgZj8X4Ahw
FtAJcDOgGKJvZvwgRSpkJ5AD8DKxFvE0wW8FsS1xGUE5JGIW0AORb30FMGkCIBpkAhAFwA+Adrsu
MgORYRfgA3E68GMt0f8WwACBLnE4ETNALXELUBbQOydhBCBwF+EucQORTULeUhgAOCAW8RpkYwhw
CXC/AjAt1DzBLnEnYBbBKAWx+kVA+CtB0EIgPTEZUAWxhkwHcBjgKSkgPTMx9y6lPmIaZCgGEDdB
J2E5cicsUC7wJ3ApPxpqRXbzBJBF8W5jGMEugRhQM6D/J5A20jJyNVEtZDjELeM38cc8UURXSGMg
bm8aZEkU/xgTN/IgkEgBAHAZUD+kFoD7GJA48m83EAuAQ1EX4Uhg8xaAThVuJwVACQAuUieQ5xjg
GmQkMGdoBUA6ckt1vzpwO5EzsUjkT/IW4GEu0M8YgTlSOCAY4ShiFoA9E35kLjIW8S4QGmRJdj3r
KfwuIBYAP7M0wS6gUrUZAPtF4jggIhbAJKEuQThFF7D/F3AaZFTkFuNA6RFwPnM/pL8YgEB1UyJY
UzNARYYvRkT7QdIaZHAi8ACQAmAWgDbT9xxANKEy0HAFkAaQCJBEw49QwUfwGKJgmUlTUBaR/zJR
ASA+YEBxLjFMBzgCFvI/LqJXQyeQGENRZBkQcmvFGltENTJTUUw7wjqC+xaAWPVrS+AD8C5BSGAW
sP8+YmUaaNMKsTzRGTAKwUGSjxpkBABGtVegRS5nV5G0NC8oEC8ocR0gPicT/RpbQWjxFvAIYFGB
MlIYM/9GuyLqGmRIcSNiJPoabm1h/x0jda92v3fPHqY4NgXQJIF/LjJDoCTQV6B6uCSyD7ByL0eR
Ks8aeRIBAH4QAwAQEAAAAAADABEQAAAAAAMAgBD/////QAAHMJDYvbxpT7wBQAAIMJDYvbxpT7wB
CwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQ
hQAAAAAAAAMABYAIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAC3DQAAHgAlgAggBgAAAAAAwAAAAAAA
AEYAAAAAVIUAAAEAAAAEAAAAOC4wAAMAJoAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAv
gAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADCACCAGAAAAAADAAAAAAAAARgAAAAARhQAA
AAAAAAMAMoAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgBBgAggBgAAAAAAwAAAAAAAAEYA
AAAANoUAAAEAAAABAAAAAAAAAB4AQoAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAA
AAAeAEOACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAHgA9AAEAAAAFAAAAUkU6
IAAAAAADAA00/TcAAIDr
------ =_NextPart_000_01BC4F48.5B7E6160--