convert date MM/DD/YYYY to DD/MM/YYYY

[rolf1994]

Hi,

I have the following problem:

I want to concatenate the end of month and start of month date in the ChargePeriodFilter column. I made this Column using the following function: ChargePeriodFilter = CONCATENATE(OfficeInvoiceItem[Start of month chargestartdate];CONCATENATE(" - ";OfficeInvoiceItem[End of month chargeEndDate]))

I expected it to concatenate as follows: "1/12/2016 - 31/12/2016" but it came out as "12/1/2016 - 12/31/2016".

How can i fix this?

[Dog · Accepted solution]

Hi, 

you may need to format them manually, looking at screen shot it looks like they are formatted in UK format at a column viewing level but back end would be stored in US. 

ColumnName = 

var StartDate = format(OfficeInvoiceItem[Start of month chargestartdate], "dd/MM/yyyy")

var EndDate = format(OfficeInvoiceItem[End of month chargeEndDate], "dd/MM/yyyyy")

return 

CONCATENATE(StartDate;CONCATENATE(" - ";EndDate))

or 

ColumnName = 

var StartDate = format(OfficeInvoiceItem[Start of month chargestartdate], "dd/MM/yyyy")

var EndDate = format(OfficeInvoiceItem[End of month chargeEndDate], "dd/MM/yyyy")

Return 

StartDate & " - " & EndDate

[rolf1994]

Solved, thanks!