Formatting a Date

[Tourniquet]

Getting actual date in query, and format that date

Hello, i do have a problem

I have to create an invoice nr. base on : pandnummer, huurnummer and datum

now i have created the following field in a query with an "expression".

factuurnummer: [pand_pandnummer] & "/" & [gefact_huurdernummer] & "/" & [datum]

pand_pandnummer = OK
gefact_huurdernummer = OK
datum = OK, but shows up like : 21-12-2003, it should be like 0312.

Datum is also a field in the query, looking lik this :

datum : date()

My question how do i format the received dat to 0312. I searched the forum for an hour, and know that i have to use format for creating like this.

I really don't know how to use the format function. PLEASE HELP ME !!

 

[Mile-O]

datum: Format(Date(), "yymm")

 

[Tourniquet]

Thanks, works great !