273
Views
6
Comments
How to asssigne date time data type to Null value?

How to asssigne date time data type to Null value?

2019-11-11 17-10-24
Manish Jawla
 
MVP

Hi Tushar,

You can use the Nulldate()  function available within the OutSystems to assign null value to date & datetime type.

Hope this helps,

Regards,

Manish Jawla

2021-06-03 11-03-21
Anubhav Rai

Hi @Tushar Verma ,

You can use "DateToDateTime(NullDate())" to get the null datetime (1900-01-01 00:00:00 ).
And simple "nulldate()" will also work if you assign it to datetime variable.

Regards,

2020-11-10 07-09-26
Dadi

Hi @Tushar Verma 

You can check default values documentation in Outsystems here for your reference:

Default Values on Database - OutSystems 11 Documentation 

OutSystems Platform always assumes default values for the built-in types. Here is the available date time:

Does it return any issues for using default datetime values? If still needed to put NULL you can check this documentation:

How to insert a null value into a database record - OutSystems How to Guide

UserImage.jpg
Iqbal Mohammad Dudyala

Hii Tushar,

 can you use the Nulldate()  function available.


2025-09-25 14-38-22
Lokesh Kumar Yadav

Hi Tushar,

In the expression you can assign the NullDate() to your variable

2025-09-25 14-38-22
Lokesh Kumar Yadav

If you got the solution then please marked as a solved

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.