Updating a column in a table with only dates with in 365 days

[robs67stang]

Good morning.  I am having issues figuring out how to format a column in a table to only show dates within 365 days of the current date, but leave the blanks in the column for the dates outside of that parameter.  I need the blanks due to may pie charts uses them to calulate completed training courses versus not completed, or expired, training courses.  I have included a snapshot of one of the columns I'm trying to format.  All the dates are currently within 365 days, but I need them to go blank as they expire.  Any help would be greatly appreciated.  Thank you.

[robs67stang]

Alexander,

  That worked great.  Thank you for your help!

[barritown · Accepted solution]

Hi @robs67stang,

You could create a calculated column like the one below and use it instead.

In plain text:

Calculated Column = IF ( DATEDIFF ( [Default Date], TODAY(), DAY ) < 365, [Default Date], BLANK() )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian