Hi,
You could just use the datediff/dateadd commands....
Dim tmpdate As String
tmpdate = "08/14/2025" ' put your date here.....
If DateDiff("yyyy", Now, tmpdate) > 0 Then
tmpdate = DateAdd("yyyy", -100, tmpdate)
End If
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Walker, Reese
Sent: Wednesday, July 30, 2008 12:12 PM
To: [email protected]
Subject: [Talk] Format Date
I have a script that pulls information from the insurance screen in STAR
to allow us to run batch eligibility checks for our series patients. I
came across an eligibility rejection that said "Date of Birth cannot be
in the future". It turns out the date in star is 08/14/25... meaning
1925 (Medicare, obviously), but BWS formatted it to 2025. How I make
sure that any Date of Birth before today never gets formatted as a
future date. I guess if we had a patient with a DOB of 1908 they would
be an exception, but the chances of that are probably pretty slim.
Thanks in advance,
Reese
Reese E. Walker
Financial Systems Analyst
Phoebe Putney Memorial Hospital
Albany, GA. 31702
Phone: (229) 312-4259
Pager: (229) 431-7658
Fax: (229) 312-4316
________________________________
Disclaimer:
The HIPAA Final Privacy Rule requires covered entities to safeguard
certain Protected Health Information (PHI) related to a person's
healthcare. Information being faxed to you may include PHI after
appropriate authorization from the patient or under circumstances
that do not require patient authorization. You, the recipient, are
obligated to maintain PHI in a safe and secure manner. You may not
re-disclose without additional patient consent or as required by
law. Unauthorized re-disclosure or failure to safeguard PHI could
subject you to penalties described in federal (HIPAA) and state
law. If you the reader of this message are not the intended
recipient, or the employee or agent responsible to deliver it to
the intended recipient, please notify us immediately and destroy
the related message.
CONFIDENTIALITY NOTICE: This message and any included attachments are from
Salinas Valley Memorial Healthcare System and are intended only for the
addressee. The information contained in this message is confidential and may
constitute inside or non-public information under international, federal, or
state securities laws. Unauthorized forwarding, printing, copying,
distribution, or use of such information is strictly prohibited and may be
unlawful. If you are not the addressee, please promptly delete this message
and notify the sender of the delivery error by e-mail or you may call Salinas
Valley Memorial Healthcare System's Privacy Officer in Salinas, California,
U.S.A. at (+1) (831) 755-0751.
