I am trying to concatenate a Date and a sequence number, but am having trouble. My Syntax is below in red.
The NativeQuery.createdon = 5/30/2018 8:27:29 AM
The first Sequence Number should be 000001 with the leading zeroes
This is what I get: 20182730-1
The date is not depicted correctly and the sequence number has lost the leading zeroes. Thoughts? Syntax below.
direct 615.326.9852|mobile email@example.com | nusoftsolutions.com
You would use the FORMAT() function similar to this example.
Your field name may be different than in my example.
This Question already has a 'Best Answer'. If you believe this answer is better, you must first uncheck the current Best Answer