Options

Format date question

emastoloniemastoloni Member Posts: 3
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?

Comments

  • Options
    MChilariMChilari Member Posts: 47
    You can use the format function as follows:

    FORMAT(TODAY,0,'<Month,2>/<Year,2>');
  • Options
    einsTeIn.NETeinsTeIn.NET Member Posts: 1,050
    FORMAT(YourDate,0,'<Month,2>/<Year>')
    

    <Year> = 2 chars
    <Year4> = 4 chars
    "Money is likewise the greatest chance and the greatest scourge of mankind."
  • Options
    emastoloniemastoloni Member Posts: 3
    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>
Sign In or Register to comment.