place current date in field.

[#1]

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

[MK_QSL]

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;

[rubenmarin · Accepted solution]

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

=Date(ReloadTime(), 'YYYYMMDD')

[Anonymous]

='Last Updated On' &' '&

ReloadTime()

for reload date time

[awhitfield]

Hi Aissam,

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

Regards

Andy