Skip to Content (Press Enter)
UserImage.jpg
Colin Crawford
2Views
4Comments
Hide default date
Question
Start Date Time 01-01-1900 00:00:00
End Date Time 01-01-1900 00:00:00

I have an example where a record is saved with default value for date.  However, where the date is the default value, I want to hide it from the user.  I tried enclosing it in an IF with the condition <date_colum> = "'#01-01-1900 00:00:00#" but this doesn't appear to work.  Any ideas?

0
0
26 Nov 2013
Copy Link
2019-03-09 06-12-44
Mac mac
Hi Colin,

That became a problem with my project too, I used a variable and assign it to the textbox as a work-around.
Don't forget to use that variable in displaying or saving the date.

Regards,
Mark Chua
1
0
27 Nov 2013
Copy Link
2025-07-02 19-21-41
Carla Ribeiro da Fonseca

Have you tried defining the "default value" property in the textbox widget to #1900-01-01 00:00:00# if you're using a DateTime, or just #1900-01-01# for a Date?

0
0
27 Nov 2013
Copy Link
2019-06-17 07-29-54
Hermínio Mira
Hi Colin,

" I tried enclosing it in an IF with the condition <date_colum> = "'#01-01-1900 00:00:00#" but this doesn't appear to work.  Any ideas?"
Change it to "<date_column> = nulldate()" and try again.

Cheers,
Hermínio Mira
1
0
27 Nov 2013
Copy Link
UserImage.jpg
Colin Crawford
Hermínio,

Perfect....  Works a treat.  Thanks.

Colin
0
0
27 Nov 2013
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.