Get a varchar field from table

[l_denivelle]

Hi

I have a table which gives me the last refresh dates of data.

I just want to put in a textbox a text like :

="Last refresh on " & MyVariable

My table looks like that :

I want MyVariable to contain the DATE_VALUE where DATE_MNEMONIC=DATE_EXTRACT_OPTIFORM.

How can I do this ?

Thanks

[senpradip007]

Do you want ="Last refresh on " & ReloadTime()

[l_denivelle]

No

I need the DATE_VALUE from my Table when DATE_MNEMONIC = "DATE_EXTRACT_OPTIFORM"

Because refresh of my data depending on an extraction from a system.

The data do not depend on the application reload.

[SreeniJD]

Hi

Use set analysis and filter the data as required...

DATE_MNEMONIC = "DATE_EXTRACT_OPTIFORM

HTH,

Sreeni

[jonathandienst]

=Date(Only({<DATE_MNEMONIC = {'DATE_EXTRACT_OPTIFORM'}>} DATE_VALUE))

or

=Date(Max({<DATE_MNEMONIC = {'DATE_EXTRACT_OPTIFORM'}>} DATE_VALUE))

[jonathandienst · Accepted solution]

[l_denivelle]

Thank you, it works.

I didn't know the "only" function !