QV button take current date

[cmano]

Hello guys.

I have data from 2027 & still going on.

I want to create a button that it will take data from the current month of the current year.

I have try the below but i have not result

that's my script:

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET FirstWeekDay=6;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET FirstMonthOfYear=1;
SET CollationLocale='en-US';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';


Stories:
LOAD Item,
Type,
[Inspection(s) Type],
Title,
Status,
Created,
Revised,
Closed,
Resources,
Elapsed,
[Number of Items],
Product,
Application,
[Applicable Specification],
Form,
[Material Description],
[Material Designation],
[Material Temper],
[Outer Diameter (mm)],
[Wall Thickness (mm)],
Customer,
[Origin of Manufacturer],
Manufacturer,
[Reported By],
Day(Created) as Day,
Num(Month(Created)) as Month,
Year(Created) as Year,
Date(Timestamp#(Created,'DD-MM-YYYY hh:mm:ss[.fff] TT'),'DD/MM/YYYY') as [Created Date]

Created is a date time filed e.g : 05-08-2022 1:16:01 PM

At button i have the below :

Actions :   

                 Select in Field

Field : 

              [Created Date]

Search String:  

                ='>=' & Date(Max([Created Date]))

                 //='>=' & Date(MonthStart(Max({1}Date)), 'MM/DD/YYYY') & '<=' & Date(MonthEnd(Max({1}Date)), 'MM/DD/YYYY')

any suggestion?

Thank you for your time.

[Chip_Matejowsky · Accepted solution]

Hi @cmano,

Think your question has been answered before. Have a look at the following past Community threads:

• https://community.qlik.com/t5/QlikView-App-Dev/Current-date-button/td-p/1106397
• https://community.qlik.com/t5/QlikView-App-Dev/How-to-create-a-Today-Button/m-p/891030#M998604

Best Regards