date from timestamp in string format

[#1]

how to fetch date from timestamp in string format

PFA for the same

[phaneendra_kunc]

You can write Date(Your_Field, 'MM/DD/YYYY')

[MayilVahanan]

Hi

Try like this

Date(Date#(FieldName, 'MM-DD-YYYY HH:mm'),'MM-DD-YYYY')

[tresesco]

Date(Floor(Date#(Field, 'DD-MM-YYYY hh:mm'))) as Date

[qlikmsg4u]

Use this in script

Date(Floor(Timestamp#(YourDateField,'MM-DD-YYYY hh:mm')),'MMM-DD-YYYY') as Date

Ex Output: Nov-03-2000

[dionverbeke]

Hi,

If you wrap a date around a timestamp you can have duplicate dates in a listbox.

It is best practices to split the datetimestamp in two fields:

date(subfield(timestamp,' ',1))  as date_timestamp

and time(subfield(timestamp,' ',2)) as time_timestamp

Kind Regards,

Dion

[maxgro]

LOAD

  @1 as Source,

  Floor(Date#(@1,'MM-DD-YYYY hh:mm')) as DateNum,

  Date(Floor(Date#(@1,'MM-DD-YYYY hh:mm'))) as Date,

  Frac(Date#(@1,'MM-DD-YYYY hh:mm')) as TimeNum,

  Time(Frac(Date#(@1,'MM-DD-YYYY hh:mm'))) as Time

FROM

timestamp.xls

(biff, no labels, table is Sheet1$);