[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Date function


Il 05/11/25 16:30, Bruce Steers ha scritto:


On Wed, 5 Nov 2025, 15:24 Gianluigi, <gradobag@xxxxxxxxxxx <mailto:gradobag@xxxxxxxxxxx>> wrote:

    Il 05/11/25 16:20, Bruce Steers ha scritto:
     > Correction.
     > Date() used with only the first argument fills only the date part.

    So it's a malfunction...
    Benoit says the dates are dates...

    Best regards
    Gianluigi


No it's by design.

Did you read the wiki?...

When used with 1 or no arguments...
Result = Date ( [ Expression ] )

Return the date part of a date & time expression. If the expression is omitted, then the today date is returned.


It returns just the date part, time is null

BruceS


So it means that Date is poorly designed, how many databases with the date reported are there that now no longer work?

Gianluigi


Follow-Ups:
Re: Date functionGianluigi <gradobag@xxxxxxxxxxx>
References:
Date functionGianluigi <gradobag@xxxxxxxxxxx>
Re: Date functionBruce Steers <bsteers4@xxxxxxxxx>
Re: Date functionBruce Steers <bsteers4@xxxxxxxxx>
Re: Date functionBruce Steers <bsteers4@xxxxxxxxx>
Re: Date functionGianluigi <gradobag@xxxxxxxxxxx>
Re: Date functionBruce Steers <bsteers4@xxxxxxxxx>