formatting a date in a string also including text

[GDewez]

Hi there,

I have to format a date following dd-mmm-yy in an expression also containing text.

Expr1: "Text" & " " Date()

Although separately formatting the date is easily done. I need to keep both int he same expression.

 

[wazz]

hello.

basically it's what you wrote, plus the formatting:
Expr1: "Text" & Format(Date(),"dd-mmm-yy")).

or:

Expr2: [tblName]![fldName] & " (" & Format([tblComposition]![COMPN_DATE],"dd-mmm-yy") & ")"

 

[GDewez]

Wazz,

It is now asking for the parameter of dd, then mmm, then yy. Then there is a message that the expression is too complex.

How come Access does not recognise d m and y anymore? It is not recongised in the Input masks either.

 

[GDewez]

Found it now.