LOGIC HELP

[abhaysingh]

hI,

iN a calendar i have date for whole month, let sat for jan 1 to 31

now i need to check todays date let say, 27 jan 16

than it should calculate less than days , todays days, output is 26 days for jan month.

kindly help

[jonathandienst]

First load the dates as proper QV date fields, then use something like:

   =  Floor(myDateField) - MonthStart(myDateField)

[Anonymous]

use: day(today())-1 gives you 26 for today

[Anonymous]

like this?

=count({<Date={'>=$(=date(monthstart(today),'YourFormat'))<=$(=date(today,'YourFormat'))'}>} distinct Date)

[Peter_Cammaert]

Do you want this expression to work only for the current month? Or also for all preceding months?

For example, if today is Feb 4th, the expression needs to return 3 for February and 31 for January?

[Anonymous]

If it is like Peter Cammaert asked for all preceding months, then replaced today() with max(Date)