What parameter sets a field's automatic presentation format in a table?

[julioarriaga]

I set up a script with a Today() function and the table displays automatically the Date format (image 1), what parameter controls this?

I tried searching on the Settings -> Document Properties in Number and Tables sheet to no avail (image 2 and 3).

Thanks in advance.

[Anil_Babu_Samineni]

You must aware of SysDate() in DB. The same functionality works as Qlik products. Here, the date format working as System date format of your Machine

[Anonymous]

if I use today() within a textbox, I get the following value (German date format)

So I suppose, that the return value of today() is (dual) date instead of num,

although it is displayed as num...

(QV11.2 SR15)

[trdandamudi]

It takes it from the script main tab:

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Hope this helps...

[julioarriaga]

Thanks, but my question is, what parameter is asigning it as a date? Not where it obtains the type of date format.

[Anonymous]

as I wrote below, in my opinion it makes no sense as you see at my textbox example...

[julioarriaga]

But where is the tag that presents it as a date? The dual presents it as numeric and integer.

Or where is the presentation/number parameter that puts it as a date?

[swuehl · Accepted solution]

Have you tried to increase the width of the column in the Fields properties?

Seems like there are more tags to come...

[Anonymous]

you're right

load today() as test AutoGenerate 1;

But why is it $date, if the return value is num ?!?

[swuehl]

Maybe because the return value is in fact a dual?

today ‒ QlikView

Don't take the auto completion and even the HELP for 100% correct...