Greetings,
Loading from a text file would likely keep the formatting.
Another approach would be to take what Excel gives you and reformat the data
"on the fly" in the script using BWS's StringFormat command.
I got burned on this command last week because someone had a similar
question and was running 6.5 - so this is V8+ only J
This shows its use against a DataStation field named MyDate:
"enter the value"
Enter StringFormat(d("MyDate"),FormatString:="mm/dd/yy")
Set a flag
F("mydate")= StringFormat(d("MyDate"),FormatString:="mm/dd/yy")
Regards,
Thom
Thom C. Blackwell
Product Manager
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com
LEGAL NOTICE Unless expressly stated otherwise, this message is confidential
and may be privileged. It is intended for the addressee(s) only. Access to
this E-mail by anyone else is unauthorized. If you are not an addressee, any
disclosure or copying of the contents of this E-mail or any action taken (or
not taken) in reliance on it is unauthorized and may be unlawful. If you are
not an addressee, please inform the sender immediately, then delete this
message and empty from your trash.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Sexton, Kevin
Sent: Saturday, October 06, 2007 9:59 PM
To: [email protected]
Subject: [Talk] formatting date to load to Meditech
The format my date needs to be when loading into Meditech is mm/dd/yy.
What is the smartest way to re-format my date?
I run a report from SQL which returns a date field. 10/31/2007. Even if I
re-format it. When it loads to excel it converts it back.
Should I load form a text file?
Thanks,
Kevin
