### Title

Formatting different types of data in one field

### Post

I have a calculation field in which I mix Date and Amount of money.

If I that same date and amount of money in a merge field, i.e. <<date>> | <<amount_of_money>>, then i'm able to give 2012-02-21 date format instead of 2/21/2012 and 1.350,00 Lt. instead of 1350 Lt. for money.

However, if use calculation field with the formula date & " | " & amount_of_money, then, when i use that field in a type of merge field alone (i.e. <<calculation>>), i'm not able to format neither date, nor amount of money (or decimal).

As for date, i could get the desired effect, if i put it like this year(date) & "-" & month(date) & "-" & day (date).

But how do i get thousand separator and fixed 2 decimals?

I'm sure there's a solution to this.

I have a calculation field in which I mix Date and Amount of money.

Why would you do that? the best solution to this issue is to not put two kinds of data into the same field. This causes more problems for you data than just the formatting issues.

You are on the right track for how such a field would need to format the data with your date calculation. If you add in this expression for the number:

Let ( m = amount_of_money ; int ( m ) & "," & Left ( ( m - int ( m ) ) * 100 & "00" ; 2 ) )

But I don't recommend combining the data like this unless you have no alternative--such as in the body of an email.