Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

add date value automatically

Dear All, Hope someone can help me with the following: I have a table with a column DATE IN with date values. Sometimes one of the fields in this column is empty. I want to add an extra column (c...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , a new column

    if [date in] = null then DateTime.Date(DateTime.LocalNow()) else [Date in]

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , a new column

if [date in] = null then DateTime.Date(DateTime.LocalNow()) else [Date in]

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi amitchandak ,

     

    Thanks for your help, problem solved.

     

    John