left in script

[johanlind]

I have a filed (Orderdate) like this:

2011-06-14 11:02:59
2011-06-14 11:03:09
2011-06-14 15:14:43
2011-06-14 11:02:50
2011-06-14 14:44:37
2011-06-14 13:51:33

How do I do for just read out the orderdate?

I have tried to use left i the script

date(left(Orderdate,10)) as OrderDate

It will return:

2011-06-14

2011-06-14

2011-06-14

2011-06-14

2011-06-14

2011-06-14

I just want one post with 2011-06-14 not six posts.

[kaushiknsolanki]

HI,

   Try this way.

    Load

   Date(OrderDate) as OrderDate

   From XYZ

Regards,

Kaushik Solanki

[johanlind]

I've tried it also but the result is the same.

[nagaiank]

You may try

Load Distinct SubField(OrderDate,' ',1) as OrderDate1, ...

From ...

[kaushiknsolanki]

Hi,

   From where are you getting this data...?

   Try this too.

    Date(Date#(OrderDate,'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY') as OrderDate

Regards,

Kaushik Solanki

[Miguel_Angel_Baeyens · Accepted solution]

Hello Johan,

Did you try?

Date(Floor(OrderDate)) AS OrderDate

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[johanlind]

Thanks Miguel

Now it works fine.