how can i input SQL server data by date wise or by selecting duration (for e.g one month data)
@139222 if the data is in a table that resides on a SQL Server database that you have access to, then you can via the Input data tool.
This link can help you get started:
https://help.alteryx.com/current/designer/connect-sql-server-database