on 06-27-2016 7:01 AM
Hi,
I would appreciate your help please in dropping a comma
I've created a string variable in the "Variable Editor" which goes like this:
=Year([due_date])+"-"+"Q"+Quarter([due_date])
*[due_date] is a date variable
I was wondering how can I drop a comma from year segment of the result
instead 2,016-Q4
to receive 2016-Q4
Thank You
Hi,
Try the following formula: =FormatNumber(Year([due_date);"#") +"-"+"Q"+Quarter([due_date])
Didier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Devteam
Try to do this :
REPLACE ALL OCCURENCE of lc_comma in lv_string with space and see if it helps
Regards
Vinita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.