I am using a cloudpage to display some general metrics on a data extension.
Having trouble displaying
rowCount based on a field called
%%[ var @count, @today SET @today = Format(Now(), "MM d, yyyy") SET @count = RowCount(LookupRows('PlayTogetherWinTogether_Entries_Main','entry_date', @today)) ]%% %%=v(@count)=%%
A sample of the date of entry displays in the data extension as
Monday, December 11, 2017 11:32 PM.
Basically just want to grab new records from today.
The simplest way (by sticking with AMPScript) is to use a lookuprows to get all your entries, and then use a FOR with IF ELSE statement. This will only work though if you have a universal identifier in the data. E.g. I usually use a column named 'secret' that defaults to a value of 1.
If you do not already have a field like this, what I would recommend is first to add a nullable field named 'secret' with a default value of 1 to 'PlayTogetherWinTogether_Entries_Main'. Then you can either create a SQL Query to update the value or export and import with the update made in excel or similar editor.
Then select the target DE as 'PlayTogetherWinTogether_Entries_Main' and update type as 'Update'.
Below would be sample AMPScript:
It is not as efficient as ROWCOUNT and LookupRows, but it should do the trick.
I have not tested the sample script, so if it throws an error, let me know and I will adjust accordingly.