You’re offline. This is a read only version of the page.
102
Hi
I'm trying to configure a customer account statement which can be used in multiple LE, with multiple date formats i.e UK and US.
I have set the over all format to use the user preference and this works for the Date & Time field within the Document Details and the other dates still remain in UK Date. I asked my colleague in US to run the same report and her CAS was produced with US date format apart from one field with is Due Date, this still remains in UK date format:
Can someone advise if there is a bug with field, or if i am missing something.
thanks
Hetal
I have now managed to figure this out.
The due date is tied to Multiple label - the formula on the statement was:
IF(
NOT(model.ReportParameters.PrintPaymentSchedule),
IF(
LEN(@.'$MainLine'.MarkForPaymentSchedule) = 0,
DATEFORMAT(@.'$MainLine'.DueDate, "dd/MM/yyyy"),
@"GER_LABEL:Multiple"
),
DATEFORMAT(@.'$MainLine'.DueDate, "dd/MM/yyyy")
)
I changed to:
IF(
NOT(model.ReportParameters.PrintPaymentSchedule),
IF(
LEN(@.'$MainLine'.MarkForPaymentSchedule) = 0,
@.'$MainLine'.DueDate, @.'$MainLine'.DueDate
),
@.'$MainLine'.DueDate)
The due date is now using the date format which is configure within their Windows setting. When i switched my setting to Date Time (UTC-06:00 Central Time (US & Canada)) and Region to English (United States) and then reloaded the excel it picked up the US date format
Thank all. :)
Share
Report
All responses (
Answers (
