topic Re: Setting a date format and using the date the calculate how long it's been since the date in the data in QlikView

Setting a date format and using the date the calculate how long it's been since the date in the data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a dates that equal

6/24/2013 0:00

How do I define that this data is datetime format?

How do I find out what today is? Today()?

aarkay29 — Thu, 23 Feb 2017 23:07:45 GMT

Date#(Field,'MM/DD/YYYY') to define and interpret that it's a date field in specified format.

yes today() to return present day.

piotrtk — Thu, 23 Feb 2017 23:08:06 GMT

Hi,

You need to use Date and Date# functions. Also, use script command 'SET DateFormat = .....' to setup right date format you want to use.

Example code will generate value '2017-06-24' in variable vDate:

//---------------

SET DateFormat='YYYY-MM-DD';

LET vDate = date(date#('6/24/2017', 'MM/DD/YYYY'))

//--------------

You are right - Today() function returns current date.

Regards,

Piotr

Fri, 24 Feb 2017 02:28:37 GMT

Try this ..

FRAC(date#(6/24/2013 0:00,'MM/DD/YYYY'))

and today() function will return today date

sumitjadhav — Fri, 24 Feb 2017 09:53:56 GMT

Please Provide a Dummy Data

tcullinane — Fri, 24 Feb 2017 11:06:54 GMT

today()-floor(date#([DateField],'MM/DD/YYYY hh:mm'))

will give the number of days in the difference

muthukumar77 — Fri, 24 Feb 2017 11:51:49 GMT

Hi,

Today data is Today().

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