Load DateTimeStamp as Date only

[#1]

How to load only the date portion of a Timestamp.  I tried using 'DayStart(DTSTAMP) as T_Day, but it comes across with 12:00:00 AM.  I want it to show as MM/DD/YYYY only.  When I tried the date# interpretation, it came across as text (I assume since the values were left-justified when shown in a list box).

[#2 · Accepted solution]

try Date(Floor(DTSSTAMP), 'MM/DD/YYYY')  AS [MyDateTimeStamp]

[MayilVahanan]

Hi

Try like this

Date(Date(DTSTAMP, 'MM/DD/YYY hh:mm:ss TT'),'MM/DD/YYYY')

or

Date(Date#(DTSTAMP, 'MM/DD/YYY hh:mm:ss TT'),'MM/DD/YYYY')

note :'MM/DD/YYY hh:mm:ss TT' must matches your timestamp format

[Anonymous]

All correct, just adding one more:

date(DayStart(DTSTAMP), 'MM/DD/YYYY') as T_Day

[gareth_muir]

I tried to use these but my qlik app kept coming up with a blank where I wanted an MM-YY list.

Eventually I had to separate out the MM/DD/YYYY text string inside of the Timestamp generated by my ERP, and use the DATE syntax. I did it with a left search formula which worked great -

Date(Monthstart(Left([inDateAdded],10)),'MM-YY') as Month_Scraped, //Default date format is MM/DD/YYYY hh:mm:ss.ffff