topic Re: place current date in field. in QlikView

place current date in field.

Tue, 28 Apr 2015 14:16:11 GMT

Dear QV users,

I would like to create a field that shows the current date after uploading. The dateformat is YYYYMMDD. Can someone tell me the function I should use.

with kind regards,

Aissam

Re: place current date in field.

MK_QSL — Tue, 28 Apr 2015 14:21:11 GMT

First Create a Variable

Let vToday = Date(Today(),'YYYYMMDD');

Now you have to use something like below

Load

Field1,

Field2,

'$(vToday)' as TodayDate

From TableName;

Re: place current date in field.

rubenmarin — Tue, 28 Apr 2015 14:21:45 GMT

Hi Aissam, if you want to show the reload date, there is a function to retrieve that, ie:

=Date(ReloadTime(), 'YYYYMMDD')

Re: place current date in field.

Anonymous — Tue, 28 Apr 2015 14:31:03 GMT

='Last Updated On' &' '&

ReloadTime()

for reload date time

Re: place current date in field.

awhitfield — Tue, 28 Apr 2015 14:35:38 GMT

Hi Aissam,

try =Date(ReloadTime(),'YYYY/MM/DD')

Regards

Andy