@Dblookup and date

HCL Domino Domino Forum
1

May I use @dblookup in dialog list.In this dialog list i lookup in view and column is with value date/time and convert this date to text.

for example

@Unique(@Text(@DbLookup(“”:“NoCache”;“”:“”;“view”;based_field;5;[FailSilent])));

in column 5 i have got date/time field

when user choose value from this dialig list it translates in input translation that value to date/time value with @texttotime and set that value to another date/time field on form.

Is this sequence OK? Or do anybody have better sequence for me?

Thank you

2

Subject: RE: @Dblookup and date

@Unique(@Text(@DbLookup(“”:“NoCache”;“”:“”;“view”;based_field;5;[FailSilent])));in column 5 i have got date/time field

I don’t see a problem with the formula, except you don’t have to use “”:“” to access the current database; “” will do.

when user choose value from this dialig list it translates in input translation that value to date/time value with @texttotime and set that value to another date/time field on form.

This is overly complicated. Get rid of the keyword field. Just have a button with a formula to prompt the user to select a date (using @Prompt with the choices calculated by the formula above). The button then converts the selection to a date and uses FIELD to set the date/time field.

It’s a bad idea to have two copies of a value in your document. Then you have to worry about keeping them in sync.

3

Subject: RE: @Dblookup and date

great idea.thanks to all for the responses

4

Subject: @Dblookup and date

Hi Jan,

i think that it looks ok.

Greetings

Raul