Hi all,
I'm using the function to.date() in a layout, I'm getting a number of days from 01-01-0001.

Now, I need to display the date (current date), but I can not.

How can I display it using just Easy SQL?
Is the solution num.to.date ? How do I must use it?

Thank you!

Ed.

Hi all,
I'm using the function to.date() in a layout, I'm getting a number of days from 01-01-0001.

Now, I need to display the date (current date), but I can not.

How can I display it using just Easy SQL?
Is the solution num.to.date ? How do I must use it?

Thank you!

Ed.

Hello,

TRY :

dte$()
Syntax:

function string dte$ ()

Description


This returns the current date and time in the format


Return values

A string containing the current date and time.

Context

This function can be used in all script types.

Notes
The standard variable date$ provides the current date in the format DDMMYY.
The standard variable time provides the current time in the format HHMM.
dte$() cannot be subscripted. To extract part of the return value, use a temporary string, as shown in the example below.
Example

This example prints the current time in the format HH:MM:SS.

string dat(12)
dat = dte$()
print dat(7;2), ":", dat(9;2), ":", dat(11;2)


Regards