Extract Date from TimeStamp

[#1]

So here is my problem: I extract the date from a Timestamp field from my script as following:

Date(Daystart(FechaInspeccion), 'DD MMM YY') as FI_DDMMYY,

So for the following data 2011-02-25 18:03:41.633 it normally will give me 25 Feb 11 , but the problem is that it give me 23 Feb 11. [:@]

So I have a diference of 2 days!!!!! I try also with Floor function, the same problem.

How can I extract correctly the date from a TimeStamp in my script? Thanks in advance for any help provided.

Partick

[Miguel_Angel_Baeyens]

Hello,

That is a date format that QlikView should interpret just using Date() without any other functions.

Anyway, post some dummy data so we can check further.

Hope that helps.

[boorgura]

Tested it out with both Date(Daystart(<field>), 'DD MMM YY')

and date() function

both work absolutely fine @ my end.

[#4]

If you create a Text Box with this expression you have 25 feb 2011

=

Date(DayStart('2011-02-25 18:03:41.633'), 'DD MMM YY')

It should work the same on the script. Probably is your data. Upload some QVD or data so we can test it and help you if the answers so far is not enough.