Javascript for Date prompt

I have 2 date prompts Start Date and End Date, in a report...I need to add default values to the date prompts, so that the start date is always the Wednesday of prior week and End Date is Tuesday (6 days after Start Date)... so for eg. if the report is run Tuesday (*April 5th 2011*) or any day in th ...

Date Prompt In Cognos 8.2

Hi All,Iam creating a date prompt , using a prompt page , if i run the report from my report studio or from the cognos connection the date prompt works perfectly fine... but it i dont need a prompt page and i need the date prompt in my report page , the date prompt appears as a date time prompt, whe ...

How to Set date prompt value to balnk in cognos 8.4

I need to set the date prompt value to blank in cognos 8.4. Can anyone tell me the javascript that needs to be used.in 8.2 i have the follwoing code<script language="javascript">document.forms.elements.value='';</script><body oNLoad=init()><form name="formWarpRequest">I tried ...

Date Prompt default Value Issue

I have a prompt page in Cognos 8.4 (FP2 - Service Pack Installed) report studio with 2 Date prompts (Sales date, Receipt date). Both the date prompts are optional. User can run the report by selecting either of the prompts or both.In order to capture the event of user not selecting the date prompt, ...

how to change the display of the date prompt?

Hanu Deepthi Sistla said: How to change the display value of the date prompt to Mon/YYYY in report studio cognos 8?Please help me on this. ...

Is it possible to change format of Date prompt

D Ramkumar said: Hi,Is it possible to change format of Date prompt value.I have one date prompt in which UI is set to Edit box.whenever i click any date in calendar.it appears in the format oct 2, 2008 . is there any way to display the date in the format 2008-10-02(YYYY-MM-DD)or any javascript avail ...

'From Date'is selected greater than 'To Date'in a date prompt

If 'From Date'is selected greater than 'To Date'in a date prompt,the user needs to get an error message like "Please select a valid date"for a report studio report in Cognos 8.3Please Help me in getting the Code ASAP ...

How to remove the default dates from date prompt

i have 3 prompt pages. in one of my prompt page i have 3 to 4 date prompts in my report. Here my client wants to see date prompts with no default date on date prompt. i am using following code in HTML. its removing the default date from date prompt but, one thing i found out that date prompt is not ...

i need display of date in MM/DD/YYYY in date prompt?this is the requirement.

Hanu Deepthi Sistla said: i need display of date in MM/DD/YYYY in date prompt and this is the requirement .we tried it but sql functions are not working on date prompt parameter.If it is possible let me know on it or help me in mainpulating the date using the HTML Script.Please i need help on this r ...

Default Selection of Previous Month Range in Calendar Date Prompt

Suresh Regmi said: JS Experts, I have attached a sample report. Currently, I have previous month as the default date selected in the date prompt (calendar). Would appreciate if someone could plesae help me come up with the code to make the previous completed month (eg. from 05-01-2008 to 05-31-2008) ...

Regarding Date Prompt

Gobinath M said: Hi ,My requirement is to display Date Prompt with default date which is to be the last business day of the previous month.Also user should be able to change this default date as per requirement.Can anyone help me on this???.. ...

Data from two date prompt

Rajagopal Ramanujam said: Hi,I am using 2 date prompt for Start_date and End_date . But the data is not filted and showing nothing.it works when i using date range( in_range). But the prompt page looks ugly. So i want to have two date prompt for Start Date and End Date.It works fine if i filter just ...

Defaulting date prompt to be blank !!

Richard Mabjish said: By default, the date prompt displays current date (under properties/Default Selection there is nothing specified). How can I default it to be blank and not display any date at all...? (Report Studio 8.3) ...

From To Date prompt in condtional block

Rajagopal Ramanujam said: Hi,Iam talking to you guys for prompt with conditional block in other thread. The user dont like the date range prompt the way it looks in the prompt page.They want to have from date and To date prompt side by side.I am wondering how can i do it in the condtional block. If ...

Checkbox in date prompt

Rajagopal Ramanujam said: Hi,I am using conditional block for prompts.In the date from To prompt there is checkbox and it always checked. If want to run the year or month prompt( all prompt are optional) i must uncheck the date prompt checkbox. otherwise year and month prompt is not working. I want ...

Set date prompt to yesterday's date

I am using the following script in a HTML item to display yesterdays date in a date prompt. This script works perfectly fine in 8.3. But after we migrated to 8.4, date prompt always displays yesterday's date no matter what date we pick. I am not sure how to modify this script o make it work in 8.4.H ...

Date prompt

Hi, I have a report that uses the date prompt. The slicing to be done based on the week, month and the year. Likewise the parallel period needs to be calculated for the same. How it can be achieved?I need urgent help, ...

Date Prompt in Dimensionally modelled Report

I am creating a report based on a cube on 8.4.1. Cube is MSAS cube by the way. Report will include a number of transactions last week, MTD and YTD for each product. The week is going to be last week Friday so as of today(8/12/2010), the date prompt should display 3/12/2010 which works fine. I am usi ...

How to set default startdate and end date in date prompt??

Is it possible to set the default startdate and end date in date prompt??My default date should be like below one.Default --> startdate -Jan 1,Cuurent Year end Date - Dec 31,Current YearPls suggest the way to do itThanks in Advance.. ...

reduce the size of date prompt in toolbox

I am lookin to create a custom template and I was looking to know if anyone knows that file I need to edit to reduce the size of the date prompt field. Sample screen shot of what I have and what I want it to be ...

Date prompt issue

Gurus,Kindly give me advice for my report.I have the impromptu report prompt.The user is entering the start date YYYY-MM-DDand End Date YYYY-MM-DD.Then he will get the report page with the results.How to develope this prompt page in Report studio? with Date prompt or any other option is there? ...

HOW to change the default value for date prompt

Carol Lindsey said: Hi,I'm working on a report which has a date prompt. We need to set the default value to be 00/00/0000. I am using C8.2 Any ideas on how to do this? ...

Error in date prompt

I have created the report with two date prompt (start and end date).If i run the report without validating then its throwing unresolved error in prompts.After validation if i run the report its not throwing any error and its working fine.Can any one faced same type of issues or pls give me some sugg ...

How to use answer from date prompt in calculated field...

I want to write a query on a warranty database to figure out how many days are left on a unit's warranty based on a future date.For example, if a unit shipped on 1/1/04 and the warranty is 365 days, how many days are left on the warranty as of 3/31/04?I want to prompt the user for the date to compar ...

Sharing A Date Prompt With Subreports

Is it possible to share a date prompt with subreports ? I'm prompting the user for the same date for the Crystal Reports and subreports. ...

Displaying A Date Prompt (Range) In Page Header

I inserted a date prompt (range) into a "Page Header" of a "Crystal Reports", but when I refreshed the report, the date prompt did not display in the "Page Header". What am I doing wrong ? ...

Text box filled with data from date prompt using Javascript

I'm creating a report in Report Studio using a store proc.There are two date prompts: FromDate and ToDateThere is a textbox prompt.If the user enters data in the textbox, then the date values passed to the store proc need to be "1900-01-01"Else the date range get passed as entered.I need to do this ...

How to set Default value null for date prompt ?

i 'm having a report where I want to be able to select two dates. A from date and a to date.I'm doing this with two date prompts where the user can select his from and to date.I want the date prompts to be empty / null when the report is opened then the user select whatever he wants , i found many s ...

Javascript auto-date, incorrect input into db

I am using this script to automatically set the current date on a form... However, when I post the form, it is actually putting the Day +1 into the database (the year and month are correct). So for example if I set the date to June 8, 2011 on the form, it will post into the db as 2011-06-09. I am no ...

Javascript value from Prompt to build a link

I know I'm missing something ever so small but maybe you guys can help... Thanks all<code><script type="text/javascript"> function insertLink() {var lnk = prompt("Enter Link [http://www.url.com]");var href = lnk.value;var lnkBuild = '<a href=" + href + " ...

New to JavaScript, help with prompt in new window

I'm slowly learning javascript, have a little java background. I wanted to just make a button you push to enter a prompt. The problem was I want the prompt message to print in a new window. Here is what I have. Can anyone help me with this?<html><head><script type="text/javascrip ...

javascript time/date in hidden field

I need to to have a hidden field in a form that contains the current time & date to be sent to a VARCHAR(255) field in a mysql database. The rest of the form is handled with PHP, but I can only get he server time with it.Can anyone help me figure out how to do this, my javascript is arusty, to s ...

looking for a non-javascript popup date picker

I need a date picker and I've searched high and low. All I can find are javascript date pickers and I don't know the first thing about javascript. I wish I had the time to teach myself, but I just spent 4 weeks teaching myself PHP and I have to turn out this project. Is there any such thing as a dat ...

Using JavaScript In A Prompt Page

I've been reading on how to use js within a prompt page and I seen this code just about everywhere when someone posts/answers a question. script language="javascript">var fW = (typeof getFormWarpRequest == "function" ?getFormWarpRequest() : document.forms);if ( !fW || fW == undefined) { fW = ( fo ...

Enable/ Disable Finish Button upon selection of Date using Date Prompt

I have script which makes the Finish Button to Enable/Disable. But there is a small issue, we have to always click on the Edit Box to enable the Finish Button.But my requirement is - I need to enable the button only by selecting the Date from the Calendar.Please find the script below.<text/javasc ...

hiding parameters on Cognos Connection set/view prompt values screen

I use some hidden parameters in my report. The problem is that the parameters and values show up in Cognos Connection > report properties > set/view prompt values. I prefer not to have users see those parameters.Is there a way to hide them in the set/view prompt values screen? ...

Pass system date as default in date prompt macro

I need to pass system date in a macro. Instead of harcoding value(2011-02-24), I want to pass system date dynamically. I am getting an error when I use {sysdate} function.Below syntax is working perfectly.Date = TO_DATE(#sq(prompt('Pmd','date','2011-02-24'))#,'YYYY-MM-DD')I am using 8.4 version.Plea ...

How to position javascript Alert and Prompt box?

Whenever I use the Javascript Prompt, the pop up is showing up top left hand side of the screen. Is there a way that I can position this box in the center or anywhere on the screen? Does anyone know how to do this? ...

Oracle format date prompt

how can i format a date for end-users in sql plus prompt statements?example: accept xlll prompt 'enter begin date as 99/99/99:99:99 :'i am using 24hour clock here. example: 20020108000001 ...

Microsoft Access Date Prompt

I have a query that lists dates. I want to make a prompt that will allow the user to type in a specific date or if the prompt is left blank, then it would bring up all records. I can't seem to find the syntax that works. I have used.....Like [Prompt Text:] & "*" Or "IsNull" f ...

code for date prompt in query

I'm currently using the following code in a query, in a date field to prompt for the beginning and end date:Between [Enter Starting Date] And [Enter Ending Date]Is there a way to put an input mask on the date prompts? I want to save my users from having to enter the "/". ...

Prevent string in date prompt

I wanted to do a simple date validation to disallowed string from entering when prompt. Pls guide me. Tks.Eg,"Enter the publish date in DD/MM/YYYY : ghghjb"Sorry, pls enter in DD/MM/YYYY""Enter the publish date in DD/MM/YYYY :# include<iostream># include<string>using ...

Javascript auto-date, incorrect input into db

I am using this script to automatically set the current date on a form... However, when I post the form, it is actually putting the Day +1 into the database (the year and month are correct). So for example if I set the date to June 8, 2011 on the form, it will post into the db as 2011-06-09. I am no ...

Oracle Using javascript in Date textbox

I was trying to do validation in one field using the javascript. ie, when the date in one textbox is changed then according to the date I should get a value in another textbox. .. So I tried using onChange and onBlur for that but it does not work for the Date Textbox (Date Picker) because the focus ...

Oracle Javascript-disabled date picker items

If I disable a Date Picker item via Javascript the user can still enter a date into it via the calendar pop-up: I want to prevent this. Is there any easy way to do so? All I can think of currently is to build my own date picker functionality, with the icon as an item that I can hide or show via Java ...

Oracle JavaScript Hide Date Picker

I'm trying to hide a date picker field via javascript. I'm able to hide the label and the field, but not the picker button. Any ideas?<script>function Show_On_Selectlist_Value(pParent, pValue){var rv = $x(pParent).value;if (rv == pValue) {$x_Show('P13_DEFER_DT');$x_Show('lbl_defer');} else {$x ...

Oracle Date prompt to be used in a column

Here is the user's requirement: I have created about 5-6 reports on a single dashboard page(though not a good practice, the user wanted to see this for demo), and on top of all the reports, I have the date and customer prompt. In one of the reports used in dashboard, I need to include a column in wh ...

Javascript future date help!?

I hope someone out there can help me!I am a librarian and am looking for a way to get javascript to display a simple future date for books we need to pull off our shelf. The date needs to be 6 days into the future. I want the date to display as either a hyphenated number:ie. 8-13 (for August 13th)or ...

Javascript GMT date

I am trying to create a javascript date/time script to display the current GMT date, but obviously because javasceipt is client side it displays the clients current date not the GMT date.Does anyone know how i can get javascript to show the current GMT date to anyone (even people not in the GMT time ...

Javascript change date format

I have a snippet of Javascript that changes date format from yyyy/mm/dd to dd/mm/yyyy:<script type="text/javascript">var myString = "[[date]]";var mySplitResult = myString.split("-");document.write(mySplitResult[2] + "/" + mySplitResult[1] + "/ ...