I am using the AI function to extract data off of receipts - it was pulling the dates correctly (US Format) in the beginning, but now it has changed and it is reading 1/6/2025 as June 1st, 2025 instead of January 6th, 2025. Not too sure how i can fix this?
I’d be willing to bet it’s a problem for any date less than or equal to the 12th of each month. Those dates are ambiguous and impossible to determine if there is no prior instruction or expectation. Have you instructed your AI which format the dates are expected to be in, whether it’s MM/DD/YYYY or DD/MM/YYYY? May also help to instruct it to return dates in YYYY/MM/DD format or ISO format which are internationally recognized.
Can it be something to do with the browser’s locale?
Appreciate the feedback here - it’s so strange because it was picking it up correctly in the beginning and then all of a sudden its not. I will try editing my prompt/instruction to see if this works!
I read previous support queries on this and i reviewed my Locale. It is set for English US…weird
How long have you been doing this? Did you have any dates prior to 12/12/24? Did it pop up beginning Jan 1st?
You understand what I mean though right? Everyone knows that 12/31/2024 is December 31st, but if I give you a date of 10/11/2024, is it Oct 11th or Nov 10th? You don’t know unless I specify to you what the expected date format is.
Yeah completely understand what you mean - I just managed to sort it out by adjusting my prompt in the extraction of data, so it is now reading the dates in the US format and pulling the data accordingly!
I appreciate the help here Jeff.
2 Likes