Date Conversion

Options
melliott
melliott Member, ALL USERS, Partner Posts: 5 New Contributor
in Planning & Modeling

I need to convert the text formatted data below to the date format 03/08/2022. I have a formula to do that, but the time stamp on the right interferes with my formula. How would I remove that part of the cell? Or how would I add it to my formula: DATE(VALUE(RIGHT(As Of Date, 4)), VALUE(CODE(FINDITEM(Time Conversion, MID(As Of Date, 4, 3)))), VALUE(LEFT(As Of Date, 2)))

 

melliott_0-1647446753521.png

 

Tagged:

Comments

  • melliott
    melliott Member, ALL USERS, Partner Posts: 5 New Contributor
    Thank you!!
  • melliott
    melliott Member, ALL USERS, Partner Posts: 5 New Contributor
    @rob_marshall All different transactions that ran the same day, huge list. I found a work around and fixed the date, works how I need it to. Thanks for the input!
  • melliott
    melliott Member, ALL USERS, Partner Posts: 5 New Contributor

    The data will roll up, the view i sent was of the raw data in the data hub. Not aggregated yet.

Categories