12 Replies Latest reply: Nov 4, 2015 8:16 AM by Sunny Talwar RSS

    Date and time fields- How to create derived fields

    Ignacio Garribia

      Hello Everyone! I need your help for configuring date and time fields.

      I have the date in the following format: 201503111647000 ( 2015 03 11 16:47:000). The field is called "Fecha" in the database and it is in text format.

      How can I create the derived fields from the field "Fecha"?


      I need the Year (2015), Month (11) ,Day (3), Hour (16:47), Month names( Jan, Feb,..), day names (Monday, Tuesday..), year month names( Jan 15, Feb 15)

      I would really appreciate your help .Thank you!!!

       

      LOAD

          Cliente,

          Sucursal,

          Vendedor,

          "Unidad de Medida",

          "Condcion_Comercial",

          Cantidad,

          "Costo Total",

          "Ventas Netas",

           Fecha,

      SQL SELECT

          Cliente,

          Sucursal,

          Vendedor,

          "Unidad de Medida",

          "Condcion_Comercial" as "Condición Comercial",

          Cantidad,

          "Costo Total",

          "Ventas Netas",

          "Contenido total Vendido",

          Transaccion,

          "Tipo de comprobante",

          Fecha

      FROM "C:\USERS\IGNACIO\Documents\Proyecto Pintecord\Base de datos Ventas.accdb".Ventas;