AnsweredAssumed Answered

sample id from calculate broken

Question asked by lmwinton_usfs on Jul 11, 2017
Latest reply on Jul 11, 2017 by lmwinton_usfs


I have been assigning sample ID using a calculate field from the date and time as shown below. It used to work perfectly (although made a very long sample ID) However, since the last update it no longer works and just returns "GO_" in our surveys. I have a feeling this has something to do with the change from epoch? But I scarcely know what I am talking about. At any rate, can you suggest a fix? I also attached the full .xlsx just in case.




dateTimeDATESDate and timeyesnow()yes${specimen_collected} = 'yes'
textcalc_sample_idSpecimen label${specimen_collected} = 'yes' concat("GO","_", date(${DATES}))