retrive the date from another table

[happydermis]

Hi all!____I am trying to get a date from a different DB table than the table I am using for the rest of my report. I want to avoid creating a new index since I don^t know what problems suhc a move might produce...__I tried using flexLink but got strange values. Than I tried to use DTLOOKUP but got the wrong date and also the time even that I requested a value without the time. Than I treid DLOOKUP - I get a blank field even that in the help file claims that it is possible to import a date with the DLOOKUP function.____A date looks like this in the table: 25.4.2004____What am I doing wrong? :-(

[kfleming]

Try a flexlink using the DTOC() function with the optional ,1 argument to put the dates into a yyyymmdd format. You would need a calculated linking field in the same format.____To use the lookup functions, you do need to have an available index.____Kathleen__R&R Support

[happydermis]

Thanks Kathleen!____It seems to work - now I only have to check if the dates I get are also the right ones ;-)____I think you have earned a @-->->--- rose...____Dekers