Can I use FINDLAST function on date and time?

PanJ

Hello guys,

I have a question.
I have to attach the last modify user's signature on report so l check it by this ..




"ApprovalEntry" keeps the last Entry No. of Approval Entry that filtered by Sales Quotation No. and status = Released.
we had no problem until this below happened




by Last Date-Time modified Entry No. 2380 was created before Entry No. 2381.

I would like to know is there the way that l can check last Date-Tim Modified instead of Entry No.?

Thank you for your help.

navdeveloper

Hi,

What about adding 'Last Date-Time modified' as a key and using 'SetCurrentKey'?

Cheers

lubost

Navision ask every index to be unique and do that by adding primary key at the end of each index. So, you have to take it into considerantion.

PanJ

Thank you guys, I'll try your advice.

sorenhinrup

To secure the unique key for this table I suggest you make a key as this: "Last Date-Time Modified, Entry No." This will sort your table on the date first and then the entry number.
And as previously mentioned by navdeveloper use the setcurrentkey on the report.

lubost

If Entry No. is the primary key, you should create key with "Last Date-Time Modified" only. Entry No. will add NAV automatically by design.