topic Date Expression in QlikView

Date Expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi how do I format a date and time into a date only expression

YYYY/MM/DD 12:00:00 AM to YYYY/MM/DD

sunny_talwar — Thu, 09 Feb 2017 16:41:52 GMT

May be this:

Date(Floor(DateandTimeField), 'YYYY/MM/DD') as Date

or if it isn't read as timestamp, then this:

Date(Floor(TimeStamp#(DateandTimeField, 'YYYY/MM/DD h:mm:ss TT')), 'YYYY/MM/DD') as Date

Check here for more understanding about date in QlikView

Anonymous — Thu, 09 Feb 2017 16:42:26 GMT

date(floor(yourdatefield),'YYYY/MM/DD')

floor could be optional

vishsaggi — Thu, 09 Feb 2017 16:42:59 GMT

Try this may be?

Replace the date with your DateField without Quotes.

= Date(Date#('2017/02/08 12:00:00 AM', 'YYYY/MM/DD hh:mm:ss tt'), 'YYYY/MM/DD')

sunny_talwar — Thu, 09 Feb 2017 16:44:05 GMT

I would use Floor() function or DayName to get rid of time component here...

vishsaggi — Thu, 09 Feb 2017 16:45:12 GMT

Got it. Yes, it is better to use the Floor() to convert easily.

Anonymous — Thu, 09 Feb 2017 16:51:03 GMT

Try;

=Date(MakeDate(Subfield(DateTime,'/',1),Subfield(DateTime,'/',2),Subfield(Subfield(DateTime,'/',3),' ',1)),'YYYY/MM/DD')