Format date question

emastoloni

In my item table we have a regular date field "Last Price Update".

I want to print this field in the following format:

Example "Last Price Update" = 09/26/2010

I would like to print 09/10

Any ideas?

MChilari

You can use the format function as follows:

FORMAT(TODAY,0,'<Month,2>/<Year,2>');

einsTeIn.NET

FORMAT(YourDate,0,'<Month,2>/<Year>')

<Year> = 2 chars
<Year4> = 4 chars

emastoloni

MChilari wrote:

You can use the format function as follows:

FORMAT(TODAY,0,'<Month,2>/<Year,2>');

That worked great! Thanks for quick reply! =D>