Hi every one,
suppose I have a field named AAA:
I want to separate 2 numbers from the right of all this field values, in another word, I need to have toe field of AAA1 and AAA2:
As I need to use tow variables of AAA1 and AAA2 in different calculations, so I think that I must use some functions on the script!
I would appreciate it if some one can help me.
Thank you in advance,
Please use left () and Right() and mid() function to separate different part the shamsi date like below:
if AAAA format is something like YYYYMMDD (13941205)
left(AAA,4) as Date_Year,
mid(AAAA,5,2) as Date_Month,
Right(AAAA,2) as Date_Day,
Thank you for your help.
I used these functions on the front end say in a table, so I could not use the created variables in another tables or charts.
Thank you very much, I used mid () function on the front end but I could not use that on the script. Now I know where was my mistake!
I have another question that if there is a kind of separator, How can I split these two parts?