Hi,
I am using PHP to insert NULL value inside SalesForce's DB (field type is Date).

I tried using NULL, it would not work.
I tried 'NULL', it would not work either.

What is expression to insert NULL value into Date field?

Thanks in advance.
Justin

I am new to SOQL. 
I am trying to write a simple query where it basically says "SELECT aDate from TableA where aDate is less than today's date"
The data field for aDate is TEXT(10), and it displays as 2017-02-28.
I googled around, but somehow, it would not retrieve the output as I expected.
I found something like using TODAY, TODAY(), SYSTEM.TODAY() etc.

If I do this this works.
SELECT aDate from TableA where aDate < '2017-02-28'

What is expression that says today's date in the text format?

Thanks in advance.

 

I am new to SOQL. 
I am trying to write a simple query where it basically says "SELECT aDate from TableA where aDate is less than today's date"
The data field for aDate is TEXT(10), and it displays as 2017-02-28.
I googled around, but somehow, it would not retrieve the output as I expected.
I found something like using TODAY, TODAY(), SYSTEM.TODAY() etc.

If I do this this works.
SELECT aDate from TableA where aDate < '2017-02-28'

What is expression that says today's date in the text format?

Thanks in advance.