Concat string

[#1]

Hello,

I want to concatenate two string which are the month and the year of a date named DateFacture, which is a field in my table, to obtain other field, I tried this with two methods but I have always an error!

for example: dateFacture=01/02/2014 , the result is: Mois Année Facture=022014

SubField(DateFacture,'/',2) & '' & SubField(DateFacture,'/',3)   as [Mois Année Facture],

or:

Concat(SubField(DateFacture,'/',2) , SubField(DateFacture,'/',3))as [Mois Année Facture],

help me please

[crusader_]

Hi,

Just use functions Year(Date), Month(Date), Day(Date).

Hope this helps.

Andrei

[#3]

Month(DateFacture) & Year(DateFacture) as NewField

[#4]

Hi,

Thank you, it helps but teh result is oct.2007

how can I convert day in number?

[jonathandienst]

Hi

Assuming DateFacture is a date:

     =Text(Date(DateFacture, 'MMYYYY'))

HTH

Jonathan

[#6]

Please use

Num(Month(DateField))&Year(DateField) as ConcatField

[Anonymous]

There is no need to concat.  If you date is in the fotmat DD/MM/YYYY, just present it in another way:

date(date#(DateFracture, 'DD/MM/YYYY'), 'MMYYYY')

[#8]

Hi,

all of your response are correct, Thank for you all