QTP and SYSDATE
Richard S. French
rfrench@axiom-systems.com
Tue, 16 Oct 2001 12:16:56 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_0003_01C1563C.726913C0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 8bit
Help! I am using QTP version 5.09.02 and trying to update a field in a
dataset called YMDTRANS. This field is FREEFORM 8 per the dictionary. How
can I use SYSDATE to return today’s date to this field such as 20011016? I
keep getting 1011016 or 218. Thanks.
Richard S. French
Professional, Academy for Healthcare Management
Axiom Systems, Inc.
'The Managed Care Systems Experts'
20300 Century Blvd - Suite 120
Germantown, MD 20874-1110
301-840-9165 x 224 Direct
707-598-3983 E-Fax
301-840-3861 Main
301-840-3873 Fax
mailto:rfrench@axiom-systems.com <mailto:rfrench@axiom-systems.com>
http://www.axiom-systems.com/ <http://www.axiom-systems.com/>
------=_NextPart_000_0003_01C1563C.726913C0
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"
eJ8+IjgQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANEHCgAQAAwAEAAAAAIAEAEB
A5AGAKwOAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAAEAAAAFFUUCBhbmQgU1lTREFURQACAXEAAQAAABYAAAABwVZdbRmxnR3U+zpCSoqcZnBKZdem
AAACAR0MAQAAAB8AAABTTVRQOlJGUkVOQ0hAQVhJT00tU1lTVEVNUy5DT00AAAsAAQ4AAAAAQAAG
DgCgENhdVsEBAgEKDgEAAAAYAAAAAAAAACtlzTGZt9MRozoA4JgGXhfCgAAACwAfDgEAAAACAQkQ
AQAAAFQKAABQCgAAzBoAAExaRnUj3UxlAwAKAHJjcGcxMjVyMgxgYzEDMAEHC2BukQ4QMDMzDxZm
ZQ+STwH3AqQDYwIAY2gKwHOEZXQC0XBycTIAAJIqCqFubxJQIDAB0IUB0DYPoDA1MDQUIfMB0BQQ
NH0HbQKDAFAD1PsR/xMLYhPhFFATshj0FNCTBxMCgzI4EY4yMxphRRdyIAdtIENFGgQ5Txp/FEAb
rxy1eXICgzNzFjERrDE2FjEe/wOCR/0J0WsgdA5QIP8kMSI/A4KeVAhwIHQPwCReNzclfyEctChI
ZWIJcHcp/yB0HsEnrhufKbYHEAGgDeBlKpU1Kx84NixPHLRC/QdAdA3gIHQvwRZsG3gHE/0dBjMo
oTI9HrcztSBWHZH/Fmwh6DO0I4gUUDdPJVcztL0m5jQWPyiIM7QqKzQkMfc8zjM8Lbs0J3E3bS+3
M7RXMUYCkQjmOwlvMEW/Zf0OMDVG6kgBR79IyUbUSPL/R19LL0rtSm9In0bvEGAaUP9QulHRUY9S
mUbUUsJRL1T/71S9VD9Sb1Y0OQ5QWYRa4YdTA1rgAoJzdHlsB5AqaAngdAAAcQMhbGkPAUAFEAFA
A/BkY3RsewqxAGBzCrBeIBbgXmJuBHVtAgBhYXV0bzEAYGRqdVxQBRBnaF50XYEKAV1QCgFpAZBw
/jADMTySDAEPVxAYCNAJwHNd4GIjbnBieWQUAzBz+G5leBcwB7AFsADAAnO5ExBjcw+QAzBf4GRh
QHRpdhOARAEQX5AxYCAaUArAYQnAYWBoIEYbAiFcEzEukF0SZmktPQ+QOGDSadNdnCpQZHLPCVBr
chaga3J3NFAhFwD+cAHQZtFej1+fYKZp02FP92JfY29kfmJtMAmAAiBwcc9lY2kwZ/BgoXQtaJAD
YQo6MDBvdjBTdWJqBQWQdHYwRGF0ZTr/aOQvwGlvan9rj2yfba9uv/9vzFygfTALgA4ScHEMMHCk
Pw5QcS9yP3NPdF91Z1Jl+2dQFwEgKjB9MASQaOQooP93/3kPeh97L3w+CGBeEAuA9mVcgGdQbAFA
fT9+T39UljCPcAjQYgqwdDh/6P1xBjIewBAWkTGB5BNQF3D4b29mgj+DT4RXkACFcHkLUHkvaKCJ
0AsRheVz/2jkGmCG34fviP+KD3w/jQ//b89w34Fvky+UP5VPllJ2Uv919HcpHZBdH14vnB9gT55k
/Y+zOZ6vn7+gz6HfhEiq4LhEb2OoIAnwBUBNnnDvZjabE2cGqwdjAECuqGayP6dghaECIDPhXEAF
oG1w7RNiRQDAAxBTXGIB0FwT/jIAUKX/pw+oH6kvnm+rz9+s363vhAu18LTQLbTyBgDruWC0AHQI
cGWwtzAgsWnPZ8CygcExsulIebOxugEXI8FmQ0XQdgJRIHtV68OgE1B3FdF9ttLE8LcQ+5nBAYBu
drAAYAnwZwCwAE2SYXgLYAJAb3kJ8Fz9ZYBwXKAAIAuQE1BnwZnAn7eQAOECMAJgAIBiZAwwexNR
CrBjARAFsMIBygFtUX8yZVxoBbB6xqJksmcAwHJnC4HLgGjJs/MvoAFBZ3bMScsBuWCd4Zw3MABQ
zNHNxTk4HsD7zBLLAHfOU8+EdsDHsABwXwswxqFcYLOwDlB2CJB3+msLgGQewNGCBPAHQBBhfwFA
DgCZklywuPDS5QIQb/e5kLeQleB0xQCMUcXy1Hf/uYAAwLiwt5CSYckguYC48f8JMrkgjHACUAdA
C5DXgQJRv9HRtlDUgNJxtxACYHfYQ58CUQAgCcC2UMYgcmvKIX+x4hchEvJ3QLSAxxETgEOoOlxc
dYBvaEFtaJD3AxAHkNvATQ3gA2Cz4AGA3CBPASAN4MrgXN12D5Prx5C08i6EIHTFQBcQtxD/lnC5
8mWAAUDGcdaABJDK4H/fgoxCvJIx8AFA34NnlGOPxIETAgCABZBsdmwAUP+4MQUAuGDjEQGQACDj
ktHR/7BBAcHjARbgD3AAALgwDND5AZAgLsPU4xYOUOOyyGH35B/lL+Y/bA/AuDAFgefv++j/6g9s
HsC4MNiw57/sf33thCnmfC6Q60/wL+1kYv8qEAKR8U/jQy/A7v/zv/TP//Xf43AooPci4//4j/mf
5nz/GmD3L/yv/b/+z+NwHZD7r/8BPwJPA1QK+bZAti+3P7hP/7lfum+7f7yPvZtFEbJWKjDhCgAh
IEkg3DHXIH9xoCBRVFAghZJpaLDgIDUuMDkTwDAg0LE6IAwQeRKyC5ASgHBk/9ti7cCXwIxwlnAI
se3AFTEfg/Fn4NJxXICWcFlNREBUUkFOUy4wMGgfN4AVlUUCslYYAUZSRcBFRk9STSCQALOx/xRg
01AWQC4AMXCz8RSAF8B+SMTwFsEc8BJA1yHAAFngU0RBVEUU0kXQwGFXICDfUBE5bxUweVDAcf51
1CDbgCzwFTMU4RpwGAfuc+PQaIAKUCCyYM5ADlAVOwA/EjFrRkBwIGf/2qAxcBLBIREhEh4wGlC/
cGY4F8IkkGtz5mAROQ3+CggiJIYIHLXvCc8K3wvv/wz/Dg8PHxAvMcEVsspQFdD/ReAqwOLSL1Gp
4FxQESKyoREzoFVUTxygWFRMmElTVCawaRAgIr+u/iIYgDbiFdA4AGfRLt8v7f+Qz5HSknUw3zHv
Mv/B9DXv/Tb7UkHgQDGWcBexdfBGUP9AICUGNa88H9vhkaBC0BrynGwsRBDScAXQbXkVkPci4YXx
RKBo0nBF0LBxtAD/IeCwMj44skB3wT7fNt0+PzNFLzdGQXgTcNxAU3mrMFDbIHNBkEk+AC4kle4n
F+BDBpZwQ0LiSbW00LfHsJbQ1hAnJJWyYDOPcO/bkLBBOcBCEELjYJZwddCvdpCqINuAU0AwJJVH
ltA/v8AHkMTxQZAXUCDBODf+NJfgIQEknURPR/83c02gxDEtzyAwLTkhMHVg7nggwJHgdxBpWRAn
gCSVkc4wNy01zxAtM88Qx2UwV4i/oEZheCSVVMb4Mzg2MMFXh7CAqeBYj343V3pYWFFvNBdnENmQ
eQ807FJ/U483kkhZUEVyUjhQTks40L/CKTA6m9PwPeNAWGBJcS1zScT+LrRhMxFf32DvN3Pi0hZS
DxWkmYCd4SEAIADQyQDqefm6zhGMggAAqgBLqQsCAFVqIANqIeBpLUJqIW0AAGEAaQBsAHQAAG8A
OgByAGYBbKFlAG4AYwBodABAa+F4bAFscGvQLfAAcwB5bmFsUG0Qa9D9bnAubUFuEmogMzAzS8EC
/2VEwgRl3zcKYw9kHW/0ZW//co9Gml4/X092b2FvYncp8EB0cDovL3d+MC69dK8vZQ97f2cvaDgw
hOD3aQ9qH4Q1PISxbXBsUGxQ6nBsgS+G8XeHM29Qbb//bs+HAG/fcO+AfzcZfc9+2v91v4xfd94I
LybfJ+8o/yoP/ysfLC8tPxCqkG+Rf5KDCA//k8+U35Xvlv+YD5kfmi+bP/+cT51fJWWfX6BvoX+i
j6OV/56Pqu+r/60Prh+j36Tvpf8Xpw6d+ISxALmwCwABgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UA
AAAAAAADAAOACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMAB4AIIAYAAAAAAMAAAAAAAABG
AAAAAFKFAAAnagEAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOS4wAB4ACoAI
IAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAAuACCAGAAAAAADAAAAAAAAARgAA
AAA3hQAAAQAAAAEAAAAAAAAAHgAMgAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAA
AAsADYAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAACwA6gAggBgAAAAAAwAAAAAAAAEYAAAAA
DoUAAAAAAAADADyACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAPYAIIAYAAAAAAMAAAAAA
AABGAAAAABiFAAAAAAAAAwBmgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALAI2ACCAGAAAA
AADAAAAAAAAARgAAAAAGhQAAAAAAAAIB+A8BAAAAEAAAACtlzTGZt9MRozoA4JgGXhcCAfoPAQAA
ABAAAAArZc0xmbfTEaM6AOCYBl4XAgH7DwEAAACCAAAAAAAAADihuxAF5RAaobsIACsqVsIAAFBT
VFBSWC5ETEwAAAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcV0lORE9XU1xMb2NhbCBTZXR0aW5n
c1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29mdFxPdXRsb29rXG91dGxvb2sucHN0AAAAAwD+DwUA
AAADAA00/TcAAAIBfwABAAAAOQAAADxOREJCS0RES0NMSUZGRkRITUhLQU9FQkhESEFBLnJmcmVu
Y2hAYXhpb20tc3lzdGVtcy5jb20+AAAAAAMABhBcfgRmAwAHEBsCAAADABAQAAAAAAMAERABAAAA
HgAIEAEAAABlAAAASEVMUElBTVVTSU5HUVRQVkVSU0lPTjUwOTAyQU5EVFJZSU5HVE9VUERBVEVB
RklFTERJTkFEQVRBU0VUQ0FMTEVEWU1EVFJBTlNUSElTRklFTERJU0ZSRUVGT1JNOFBFUlRIRQAA
AAAICA==
------=_NextPart_000_0003_01C1563C.726913C0--