Format date variables

lock
push_pin
done
Answered
2

Hi all

1. In the quote document (not details) there is a date variable, and I would like the date format to be in English, instead of Danish, i.e. October 13, 2022. I have used the variable {date} and saved the document templade with the language "English". But when a Danish user chooses the document template because he wants to make a quote for an English customer, the date format is still in Danish, i.e. "13. oktober 2022". Which factors affects the language? I thought that it was the language the template was saved in.
I have looked through the list with variables related to the document dialog and have only found the date variable in short format {sdat}. Is that the only solution? In the quote document template I prefer the dates to be in the long format, because it looks better!
Is there a way/variable where I can tell the system, that all the content in the document should be converted to English?

2. In the quote details document I have another date issue. The proposal date {sdat} is the short date, which looks nice in the table, with only limited space, but the variable for the quote expiry date is a long date format, which looks silly when the date above is in another format. Do we have the variable for teh exp. date in another format? I prefer short format for the details document because of the limited space.

How do you solve this issue with templates used in different language?

Hope for your feedback :)

24 Nov 2022 | 06:12 PM

All Replies (2)

egarding questions 1)

I ran through the same thing for a customer last week. The result was that if the customer sets the local settings in SuperOffice to be English language and English number and date format, then it will appear correctly in English in his quote document.

I don't know if this is the "right" thing to do. :) 

I can see in this documentation (https://help.superoffice.com/Documentation/Help/EN/CRM/WebHelpAdmin/index.htm#t=Template_variables.htm) that it says:

  • The date and time in template variables are controlled by the PC's system clock.
24 Nov 2022 | 06:12 PM
Really not what I had hoped for. The user won´t remember to change this back and forth. I had hoped that the language setting for the document would have indicated what date format to use. But thank you :)
24 Nov 2022 | 06:12 PM

You can manage this in Word. When editing the template, make sure to select your SuperOffice variable (using your mouse for example) and then select the correct "language" to apply.

Date format in English

 

Date format in Dutch

 

24 Nov 2022 | 06:12 PM
The good news. Once it is working "as expected", you don't have to do any more updates on such a field. Good luck!! Great to be a hero for once.... ;)
24 Nov 2022 | 06:12 PM

Add reply