OLE BD - ACCESS BD - Formula to only count today's entries

[#1]

Hi,

Please could i ask for your help...

I have created a DB, that is updated daily but i need to pull the figures out just from today??

The FX i created doesn't work:

Count({$<[Created]>*(<[Import Date]={0}>)}[Import Date])

Created is a field/measure

Import Date is the Dimension

I will then need to create a FX for 28 days and 90 days.... (+  there will be other fields added later)

Any Ideas??

[lakshmikandh]

=Count({<[Import Date]={"$(='=' & Date(Today(), 'DateFieldFormatHere') )"}>} [Import Date])

=Count({<[Import Date]={"$(='<=' & Date(Today(), 'DateFieldFormatHere') & '>=' & Date(Today()-28, 'DateFieldFormatHere'))"}>} [Import Date])

=Count({<[Import Date]={"$(='<=' & Date(Today(), 'DateFieldFormatHere') & '>=' & Date(Today()-90, 'DateFieldFormatHere'))"}>} [Import Date])

Reference : Count of records Greater than or Equal to today

[#3]

Thank You

I have tried the formula's but the count is still counting all of entries

The formula used/tried:

Count({<[Import Date]={"$(='=' & Date(Today(), 'DD/MM/YYYY') )"}>} [Import Date])

and

Count({<[Import Date]={"$(='=' & Date(Today()-7, 'DD/MM/YYYY') )"}>} [Import Date])

I have attached a screen shot of the FX

Any ideas?

[#4]

Sorry, i forgot to mention that i have created a master calendar, Please find a copy attached (just in case it helps)?

[lakshmikandh]

stalwar1‌ expert help needed

[Gysbert_Wassenaar]

What are "Today's entries"?

1. Those with today as import date?
2. Those with today as created?
3. Those with both today as import date and today as created?
4. Those with either today as import date or today as created?

[#7]

Hi,
Today's entries will be from the created field

* I have attached an amended script, just for reference *

[#8]

The only way i can get a correct customer count is:

count({<Project={"Customer Names"}>*(<DaysAgoImport={0}>)}[Import Date])

using

Today() - Floor([Import Date]) as DaysAgoImport,

[sunny_talwar]

So all is working now? Are you still need more help here