Arabic date and time field format

(0) Share

Report

Posted on by Community Member

Hello everyone,

I hope someone can help me with this. I have a date and time field at opportunity level which is set up as User Local. I'm collecting the value for this date and time field in one of the email templates. The problem appears for our Dubai users which are set up to use Arabic. Their Format is set to Arabic(UAE), language is English, Time format is HH:mm but in the email I get "02/02/2017 08:00 ص ". Is it possible to get rid of the Arabic sign?

Thank you

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

PS 23,577 on at

Like (0)

Report
Copy link

Link copied!

Hi Bobby

Users will have to customize the format from their Personal Options, as shown in screenshots below:

Or you can use the following tools to change user settings:

User Setting Utility github.com/.../XrmToolBox

crm2011usersettings.codeplex.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Prashant,

Thank you so much for that. I have already done everything you suggested and even more. It won't remove the Arabic character. Any other suggestions?

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report
Copy link

Link copied!

Do u still see the arabic character on both records n reports both?

If this didn't worked, u will have to raise a ticket to Microsoft

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes, can't get rid of it. But just to clarify(not sure if there will be any difference) that I'm seeing this in the email template when I collect {Meeting Date and Time(Opportunity)} which is added as a Dynamic Value through the Form Assistant.

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report
Copy link

Link copied!

Is it on new records u just created or existing records

I guess u ll nt b able to change it on existing records

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Ran a few tests with brand new records, even deleted the browsing history, just in case, but nothing changed I'm afraid. below are the full settings just in case I'm missing something

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report
Copy link

Link copied!

You can try report expression or trim left or replace character

Something like this stackoverflow.com/.../is-it-possible-to-use-one-replace-function-to-replace-multiple-strings-in-one-fi

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report
Copy link

Link copied!

sqldbatask.blogspot.com.au/.../remove-characters-from-left-of-string.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you Prashant but I'm not really bothered by the reports. What I understand from the discussion in the links you sent me, these are for reports only and won't apply for my email template. But please correct me if I'm wrong?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Ok, this seems to be related to the field itself and not with the settings unless something goes very wrong with my system. I have changed the user settings to show GBP as currency and language for formats but in the email template the date and time continues to show with the Arabic symbol.

Was this reply helpful? Yes No