Help

Re: #ERROR! message when I try to use "Right({String},4)" when String = numerical result of a date based formula

294 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Laura_F
4 - Data Explorer
4 - Data Explorer

I have created a random number generator string {RNGS} using this formula: VALUE(DATETIME_FORMAT(AddDate, ‘mm’)) # Autonumber # Autonumber.

(Note: I have purposefully substituted # for an asterisk/mutliply function in this post)

A sample result is 238425 (33 # 85 # 85). I’d like to use just the first 4 digits for my random number field

I’ve tried both RIGHT(VALUE(DATETIME_FORMAT(AddDate, ‘mm’)) # Autonumber # Autonumber,4)
and
RIGHT({RNGS},4)

Both of these generate the #ERROR! message. Please help!

2 Replies 2
Zollie
10 - Mercury
10 - Mercury

Thinking this might be a data type issue since RIGHT requires a string. You can can convert values into strings by doing something like "" & {some field}. So you could do:

RIGHT( "" & {RNGS}, 4)

Laura_F
4 - Data Explorer
4 - Data Explorer

Genius! That worked.
Thanks