AnsweredAssumed Answered

Primary Key and Date

Question asked by pattyred on Oct 9, 2018
Latest reply on Oct 9, 2018 by pattyred


I would like to set a Record_Key different from Primary_key based on Date of the record.

I used the following formula.

Record_Key = getasText (Date) & "_" & Primary_Key

But I get inconsistent results depending if Date is entered for example as 05/09/2018 or 5/9/2018

Any clue ?

Thank you