Forum Discussion
Post PatronDate column "NOT RECOGNIZED" !!!!!!!!!
Hi,
I wrote a calculated column formula to extract the Date only from the Date/time column. I used the INT() function to do so.
Hope this helps.
Super User
Post PatronHi Ashish_Mathur can you tell me what was the problem? everbody wants to know what happened and what to do in a situation like that in the future! :)
- Ashish_Mathur
Hi,
I wrote a calculated column formula to extract the Date only from the Date/time column. I used the INT() function to do so.
Hope this helps.
- christianfcbmx
ohhh I see I didnt realize it...unfortunately that is a Patch... I made a similar patch like that as well.... I really need to find out what is the problem... the root of the problem...thanks for trying anyways...hope there is someone who can figure it out
- Ashish_Mathur
Hi,
That is not a patch. You had created a relationship from a Date/Time column to a Date column - that is obviously not possible. You can create a relatioship only between a Date and another Date column. The INT() function extract only the Date portion of the Date/Time stamp. Once that is done, one creates a relationship from the result of the INT() column to the Date column in the Calendar Table.
Hope this clarifies.