update query base on condition

[Souris]

I would like to update my record with current date time, if the value is null.
May I add 'IF(NULL, FieldValue, Date())' in my query?
If not, are there any solution for this?
Thanks millions,

 

[adsl]

You could just put Is Null in the criteria row of the grid, lot less
complicated I would have thought.

SHeila

 

[adsl]

I would like to update my record with current date time, if the value is
null.
May I add 'IF(NULL, FieldValue, Date())' in my query?
If not, are there any solution for this?
Thanks millions,

 

[adsl]

You could just put Is Null in the criteria row of the grid, lot less
complicated I would have thought.

SHeila

 

[adsl]

I would like to update my record with current date time, if the value is
null.
May I add 'IF(NULL, FieldValue, Date())' in my query?
If not, are there any solution for this?
Thanks millions,

 

[adsl]

You could just put Is Null in the criteria row of the grid, lot less
complicated I would have thought.

SHeila

 

[adsl]

I would like to update my record with current date time, if the value is
null.
May I add 'IF(NULL, FieldValue, Date())' in my query?
If not, are there any solution for this?
Thanks millions,

 

[adsl]

I would like to update my record with current date time, if the value is
null.
May I add 'IF(NULL, FieldValue, Date())' in my query?
If not, are there any solution for this?
Thanks millions,