Extracting New entries from an Excel file

[Deano478]

Hi Community,

Recently I created an MS Form for my organisation to fill in and like every MS Form the results are sent to an Excel file.

What I Am trying to accomplish is when a new entry comes into the Responses Excel sheet I need to extract it and add it a new output so essentially everyday I need to extract all new entries if there is any

Here's an sample of three dummy entries I used as when testing my form:

ID	Start time	Completion time	Email	Name	New or Existing	Company Name	Is This a Group
1	3/7/23 15:25:58	3/7/23 15:28:39	JohnDoe@Gmail.com	John Doe	New Client	ABC Limited	No
2	3/8/23 15:28:41	3/8/23 15:30:20	JaneDoe@Gmail.com	Jane Doe	New Client	Test Inc	No
3	3/8/23 15:30:22	3/8/23 15:31:24	JoeBloggs@Gmail.com	Joe Bloggs	Existing Client	JJJ Ltd	Yes

For example today I would need to extract the last 2 records.

I know this might be a big ask but I appreciate any guidance or support that is offered for this matter.

[binuacs · Accepted solution]

@Deano478you can filter out the new records with the below formula 

DateTimeParse(]Start Date],’%m/%d/%y’) = DateTimeToday()

[Deano478]

hey @binuacs I tried the formula but I ran into this error I'm not to sure about:

[Deano478]

Never mind it worked it was silly mistake on my end

[FrederikE]

Hey @Deano478,

You got an typo in your formula - '&m/%d/%y' - instead of '%m/%d/%y' 

this causes the conversion error.

[Deano478]

Hry again @binuacs  and @FrederikE I put the formula into a filter tool as a custom filter however its telling me that there is no new records even though I have 4 for today sorry about this. here is the SS: