topic Re: Count current month in App Development

Count current month

joeybird — Tue, 13 Oct 2015 10:46:06 GMT

Hiya

in my sql data load I have Order_Date in the following format

20140101 00:00:00

this contains data for 3 years.

I have in my data load done this

Month(Order_Date) as Month

my expression is

count({$< Month ={$(=Month(today()))} >}Customer_ID)

but it is counting every order date month that contains October, I just want count for Oct 2015

if I do this

count({$< Month ={$(=MonthStart(today()))} >}Customer_ID)

I get -

Please Help

sunny_talwar — Tue, 13 Oct 2015 11:02:11 GMT

Try this may be:

Date(Order_Date) as Order_Date

Expression:

=Count({<Order_Date = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} Customer_ID)

joeybird — Tue, 13 Oct 2015 13:09:59 GMT

Awsome

thank you Sunny x

Kind Regards

ZoeM — Fri, 30 Nov 2018 16:50:43 GMT

Hey Sunny,

I have a similar issue. My expression is:

=Date(Today(),'MMM')& ', '& Count({$<[Date Type]={'VPP Dates'},YearMonth={$(=Date(Today(),'MMM'))} >}Gateways)

Expression is OK, but my result is zero.

I am trying to specify a data point for total sales for current month (November in this case).

alsahly2017 — Sun, 28 Nov 2021 05:57:09 GMT

It works perfectly.