Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Concat a date and numeric field

Avatar

Level 3

Hello all and Happy Holidays.

I am trying to ( I think) concat two fields.

The requirement is that the Invoice field will = the UserID followed by the date.

So if User ID = 1234 and the date is 12/23/13, the Invoice Number should be 1234122313.

I've tried various things and I'm not having luck.  I'm not a programmer, so have been trying to use the built in functions of FormCalc.

Any guidance would be valuable and appreciated.

I am on Version 10.0.2.20120224 blah blah blah

Also the Date field is being done by

 

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

Gretchen Sheridan

link.jpg

2 Replies

Avatar

Level 7

Put this in the calculate event for your field that will house the invoice number.

$.rawValue = concat(nfID.rawValue, Replace(dfDate.rawValue,"/"))

Change the names nfID (the user ID) and dfDate (the date field) to match what you currently have, of course.