FieldRef dates & times

bhalpin

Hi.

I've done my best in the help and searching this form, but can't quite figure out how to get a date and a time from FieldRefs. I can get the text value with FORMAT, but I need to get the values out of date & time fieldrefs into date & time variables.

Any quick pointers?

Thanks in advance.

einsTeIn.NET

I'm not sure what you really want to do, but maybe you're searching for EVALUATE?!

kriki

RecRef.OPEN(DATABASE::"Log");
RecRef.findfirst;
FldRef := RecRef.FIELD(90); // the ID of a date-field
TheDate := FldRef.VALUE;
MESSAGE('%1',TheDate);

And it is the same for all other fields.

bhalpin

Yup, and I found the answer:

EVALUATE(DateVar,FORMAT(DateFieldRef));
EVALUATE(TimeVar,FORMAT(TimeFieldRef));

Thanks!