Author Topic: Default current Month and Current year on Value prompt:  (Read 95 times)

0 Members and 1 Guest are viewing this topic.

Offline MrSpecialist

  • Sr. Member
  • *
  • Posts: 348
  • Karma: +1/-0
  • I'm an expert!
    • View Profile
Default current Month and Current year on Value prompt:
« on: December 14, 2016, 10:26:07 AM »
Default current Month and Current year on Value prompt:

Solution:
 
Pq_Date (Prompt Query):

d_Date_Month_Use: Expression: month([Date])
d_Date_Month_Display: Expression: left(monthname([Date]),3)
d_Date_Year_Display: Expression: year([Date])
d_Date_Month_Final_Use: Expression:

Case
When [d_Date_Month_Use] = month(current_date) then 0
Else([d_Date_Month_Use])
End
 
d_Date_year_Final_Use: Expression:

Case
When [d_Date_Year] = year(current_date) then 0
ELse([d_Date_Year])
End
-----------------------------------------------------------------------------
Now add 2 Drop down Prompts: (Month; year) :
Month: Drop down prompt(Value Prompt)
Use Value: d_Date_Month_Final_Use
Display Value: d_Date_Month_Display
Add Default Selections: 0
 
Year: Drop down prompt(Value Prompt)
Use Value: d_Date_year_Final_Use
Display Value: d_Date_Year_Display
Add Default Selections: 0

  -----------------------------------------------------------------------------------
Main Query— add filter:

([d_Date_Month_Final_Use] = ?P_ Month?) and ([d_Date_year_Final_Use] = ?P_ Year?

Techronnati | where technology never sleeps

Default current Month and Current year on Value prompt:
« on: December 14, 2016, 10:26:07 AM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
123 Views
Last post April 02, 2009, 06:27:43 AM
by CyborgRepublic
0 Replies
343 Views
Last post June 02, 2010, 11:35:29 PM
by h2obubbler
0 Replies
63 Views
Last post August 08, 2014, 03:17:18 AM
by rpmolecule
0 Replies
131 Views
Last post July 22, 2016, 06:42:07 AM
by MoneyRepublic
0 Replies
108 Views
Last post December 14, 2016, 10:40:34 AM
by MrSpecialist

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.