Column Type Date

NCD
Silver 2
Silver 2

I would like to create a Column, Type Date.

I would like it to capture the date it was created, but only show the year for a view.

Is this possible?

Solved Solved
1 3 89
1 ACCEPTED SOLUTION

For your Date column: 

  • Initial value: NOW()
  • Editable?: ISBLANK([_This])

You must have another "Year" column:

  • Type: Number
  • App Forumla: YEAR([Date])

View solution in original post

3 REPLIES 3

For your Date column: 

  • Initial value: NOW()
  • Editable?: ISBLANK([_This])

You must have another "Year" column:

  • Type: Number
  • App Forumla: YEAR([Date])

Thank you!

Hi @Joseph_Seddik 

When I click on "Complete", only then the dates should be entered. But my function not working. Help me.

 

[STICKER Status]=Complete, Now())

Top Labels in this Space