Help

The Community will be undergoing maintenance on Saturday January 11 at 11:59pm - Sunday January 12 at 11:59pm EST. For assistance during this time, please visit our Help Center.

Not Seeing all dateField options when creating Calendar View

Topic Labels: Views
582 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kyleigh_Smith
4 - Data Explorer
4 - Data Explorer

image

Hello,

I am trying to use the calendar view. I have many formula fields that are calculating different dates. I am only seeing two of those listed here. Is this a bug? Or is there something in the formulas that is making it not appear as a date?

here are the two formulas that do show up in the list:

  1. SET_TIMEZONE(DATEADD(DateOfReply, -1, ‘days’),‘America/Pacific’)

  2. IF(HOUR({DateOfReply_Pacific}) >=20, DateOfReply, PreviousDay_Pacific)

And here is one that I need that isn’t showing up:

  1. IF(HOUR({DateOfReply_Eastern}) >=20, DateOfReply_Eastern, PreviousDay_Eastern)
0 Replies 0