Time stamp to date conversion

[nareshthavidishetty]

Hi,

How to convert the date time stamp to date.

Please find below for reference:

Thanks..

[marcus_sommer · Accepted solution]

You could use: date(floor(UPLIST_DATE))

- Marcus

[nareshthavidishetty]

Hi Marcus,

I have convert using date(floor(UPLIST_DATE)) but the dates are not selected correctly.

Please find below for reference.

Thanks..

[marcus_sommer]

Are there further selections in other fields?

- Marcus

[vinieme12]

This should work, dI'd you have any other selections when taking this screenshot?

ADD AN EXPRESSION TO  uplist _date list box

Isnum (uplist_date)   and check if these are properdates

May have extra spaces or garbage character that we'll need to trim

[alis2063]

Dear,

You can use alt function to get desired date format,

alt(
date#(DATE_FIELD,'MM/DD/YYYY'),

) AS date

[MK_QSL]

Date(Floor(TimeStamp#(UPLIST_DATE,'M/D/YYYY h:mm:ss tt'))) as Date

Time(Frac(TimeStamp#(UPLIST_DATE,'M/D/YYYY h:mm:ss tt'))) as Time

[MarcoWedel]

DayName(UPLIST_DATE) as Date

Hope this helps

Regards

Marco