Autofill cell with current date

[NL_Erik_G]

Hi,



Here is a question about a table containing 2 columns. These are:



Barcodescan - date scan



The purpose of the form is that a user can scan a barcode so that the text of the barcode is put in the first column. Automaticly the next column should be filled with the date (and if possible) time of the scan (This means the data/time of filling the one cell).



The question is how to automaticly have the date-cell fill with the date without having the user to enter in manually.



Any help in MUCH appreciated!



Erik

[Thomas_McConnac]

xfa.host.currentDateTime()



Tom

[Thomas_McConnac]

Not sure about how its used, but know that's the command

[ibwaheemi]

a current date box comes as standard and is found under 'custom'



it puts this formcalc in the form:ready box



// Current Date in short-style date format.



$.rawValue = num2date(date(), DateFmt(1))

[Former Community Member]

Hi Joe,

On the exit event of the "barcode text field", you can set the current date of the other field by (Formcalc)

barcodeDateField.rawValue = Concat(Num2Date(Date(), "MM/DD/YYYY"), " ", Num2Time(Time(), "HH:MM"));



Hope helps

In case of consultancy issues on LiveCycle Designer and LiveCycle ES family, you can contact us.



Asiye Günaydın

Project Consultant

KGC Consulting Co.

www.kgc.com.tr

+90 312 292 02 00 - 803