date

Horse06

how to write if date is null
date :=' ' is not right. what's the correct one. Thanks!

David_Cox

Horse06 wrote:

how to write if date is null
date :=' ' is not right. what's the correct one. Thanks!

Date := 0D;
Time := 0T;

kriki

And in a filter put by the user on a field : ''

MissesMagic

David Cox wrote:

Date := 0D;
Time := 0T;

but please remember that this only works with the correct language!

If I´m not wrong, put the "0D" in brackets: "<0D>" to ignor users language!
(correct me - if this it totally wrong! )

kine

MissesMagic wrote:

David Cox wrote:

Date := 0D;
Time := 0T;

but please remember that this only works with the correct language!

If I´m not wrong, put the "0D" in brackets: "<0D>" to ignor users language!
(correct me - if this it totally wrong! )

No, this issue is just for CALCDATE function. 0D and 0T as constant is international.

kriki

And also '' is international.

MissesMagic

Why do you blame me