Forum Discussion

christianfcbmx's avatar
christianfcbmx
Icon for Post Patron rankPost Patron
8 years ago
Solved

Date column "NOT RECOGNIZED" !!!!!!!!!

I dont know if it is my computer...but the date column is not recognized WHY??????? (should be the data source???)   Any help would be so much appreciated!!!!! CLICK the link below to get the excel...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

It is working now.  Download my solution workbook from here.

 

  • christianfcbmx's avatar
    christianfcbmx
    Icon for Post Patron rankPost Patron
    8 years ago

    Hi 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's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      8 years ago

      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's avatar
        christianfcbmx
        Icon for Post Patron rankPost Patron
        8 years ago

        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