MichaelTamoush
5 years agoQrew Captain
Extract Date from Logged Field
I'm trying to extract a date from a logged field. In the example below, I am trying to get the Backlogged Date. I figured I could use a series of 'left', 'right', 'notleft' etc. However, my first try led me to something that i can't figure out.
Simply trying: left([Field Name], "Backlogged") yields this result:
[Apr-08-20
That very much confuses me, so there is something I don't understand about how logged fields are stored. Can anyone shed light? I know I would need more in my formula to extract the date, but after getting that result I stopped as I was dead in the water.
I also tried left(totext([Field Name]), "Backlogged") with the same result.
------------------------------
Mike Tamoush
------------------------------
Simply trying: left([Field Name], "Backlogged") yields this result:
[Apr-08-20
That very much confuses me, so there is something I don't understand about how logged fields are stored. Can anyone shed light? I know I would need more in my formula to extract the date, but after getting that result I stopped as I was dead in the water.
I also tried left(totext([Field Name]), "Backlogged") with the same result.
------------------------------
Mike Tamoush
------------------------------