Hi everyone, trying to set the date and time in a ...
# suiteanalyticsj
Jérémy Remacle
12/10/2019, 3:38 PMHi everyone, trying to set the date and time in a saved search in a format like that yyyy-mm-ddThhmmss.
Tried a lot of things with to_char but had all the time the error Error : Invalid Expressions.
I have the impression that to_char does not recognize {today}
Don't know what to try next
b
battk
12/10/2019, 3:41 PMwhats your current attempt look like?
j
Jérémy Remacle
12/10/2019, 3:45 PMto_char({today}, 'YYYY-MM-DD HH24MISS')
b
battk
12/10/2019, 3:45 PMlooks reasonable
battk
12/10/2019, 3:46 PMwhat type of formula
j
Jérémy Remacle
12/10/2019, 3:46 PMWhat do u mean? Type of formula?
b
battk
12/10/2019, 3:47 PMis it Formula (Text)?
battk
12/10/2019, 3:47 PMwhat option did you select in the
Fieldj
Jérémy Remacle
12/10/2019, 3:49 PMdid not select anything
Jérémy Remacle
12/10/2019, 3:49 PMMade my formula in formula
b
battk
12/10/2019, 3:50 PMscreen shot of what your doing?
j
Jérémy Remacle
12/10/2019, 3:51 PMmessage has been deleted
b
battk
12/10/2019, 3:52 PMclick cancel
battk
12/10/2019, 3:53 PMscreen shot of the row you are currently working on
j
Jérémy Remacle
12/10/2019, 3:55 PMmessage has been deleted
b
battk
12/10/2019, 3:55 PMyou are using a Formula (Date/Time)
j
Jérémy Remacle
12/10/2019, 3:56 PMyes
b
battk
12/10/2019, 3:56 PMthe expected output of your formula is supposed to be a Date/Time
battk
12/10/2019, 3:56 PMTO_CHAR doesn't output a Date/Time
battk
12/10/2019, 3:56 PMchange your field to Formula (Text)
j
Jérémy Remacle
12/10/2019, 3:57 PMahhhhhh ok
Jérémy Remacle
12/10/2019, 3:57 PMthks
Jérémy Remacle
12/10/2019, 3:58 PMDO u know how to concatenate in netsuite?
b
battk
12/10/2019, 3:59 PMj
Jérémy Remacle
12/10/2019, 4:03 PMthanks!