Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

place current date in field.

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

1 Solution

Accepted Solutions

Re: place current date in field.

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

=Date(ReloadTime(), 'YYYYMMDD')

4 Replies

Re: place current date in field.

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.

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

=Date(ReloadTime(), 'YYYYMMDD')

balkumarchandel
Valued Contributor II

Re: place current date in field.

='Last Updated On' &' '&

ReloadTime()

for reload date time

awhitfield
Esteemed Contributor

Re: place current date in field.

Hi Aissam,

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

Regards

Andy

Community Browser