I have a table with ID_ITEMITEM_NAMEITEM_DEV_DATEITEM_PROD_DATEITEM_TESTING_DATE
I need to put the ITEM_NAME+'DEV', ITEM_NAME+'PROD', ITEM_NAME+'TESTING' on one calendar,
the calendar provided by APEX is supposed to ask one date per item, so how I can put more than a date per item? So for example
ITEM ITEM_NAME='Release 1'ITEM_DEV_DATE='15-May'ITEM_TESTING_DATE='21-May'ITEM_PROD_DATE='30-May'
I have a calendar region based on a simple query from a table which has date and name columns. The calendar type is monthly with 3 buttons - previous, today & next. It works perfectly.
I have added a date picker in a calendar region now. If i choose any date, the calendar month should be refreshed accordingly. Ie... by default it would show July 2012 month. When i choose the month as March 2012 in the date picker, it should show March month data.
is there any way I can remove calendar icon from date picker?
View 2 Replies View RelatedApex 4.1.
I am using calendar to display some data but there seems to be some problem with the focus for current date. For instance : 25 Sep 2012 is today's date but the calendar focus somehow remains on 24th Sep 2012 and I am failing to understand where do I set this right. Few users see focus on correct date while few see it on previous date.
Also in another tab of the application I am using a Interactive report which displays data based on whatever calendar entries were made earlier. Here I have two regions Today and Tomorrow which pick the values from report and display them in respective region but here too Today(picks yesterday date) and Tomorrow(picks today) .
I am confused as to where to set this right because like I said few users (based in AU) are seeing this incorrect values while users located in another region see it correct.
Apex 4.2I have a page with a calendar on it. I have several issues with formatting the data within each cell. Currently, I use a substitution string to place the id in the calendar cell.
Clicking the id will link to another page. What I notice is that for each id on a calendar cell (or date), it lists them one under the other. Is there any way to list them side by side? Also, I need to make changes to the calendar cells. I would like to expand the width and the height, but am not sure where to do this.
I'm using one of the new Date/Time picker items in Apex 4.0.2. When the user clicks the Calendar image the Calendar is displayed with the current date and time. However I would like it to display by default the current date and a time of 1000hrs.
View 1 Replies View RelatedI have a calendar region using SkillBuilders plug-in. When click on an event, a modal page opens showing the event details and allowing the user to modify it. Recently, I enabled Session State Protection in my pages, so I changed my query in the calendar region to use the APEX_UTIL.PREPARE_URL function when generating the URL to edit the event. Now, when I click on an event, the URL looks like: [URL]....
p=34925:3:102130990572822::::P3_ID:41&cs=3DE8BFFE2FCA925B7716361D6ECFC546B If you notice the URL has & before the check-sum (cs), instead of just & and it is causing an error on my page. The reason is that the plug-in is escaping special characters. If I change the source of the plug-in to use this:
l_url := l_column_value_list(6)(x); Instead of:
[code]....
Version : 4.1.1, I have a tabular form on a DB table. One of the columns is a date field. When the user hits the "add Row" button on the tabular form, I want the Date field to be defaulted to sysdate. Here is what I have tried so far,
1. Created a "hidden" item P1_SYSDATE and populated the default value with sysdate. After this, under the DB tabular report date field, I used default type - Item/application on this page and entered P1_sYSDATE
2. Instead of populating the default value of the P1_SYSDATE hidden item, I created a before regions process and added
:P1_SYSDATE := sysdate
and added P1_SYSDATE to default type of the tabular date field with default type as "ITem/application on this page.
I get the error
ORA-01790: expression must have same datatype as corresponding expression
I tried to_Char(sysdate,'dd-mon-yyyy') and then converting it back to to_date. still no luck.
I want to add a date picker calendar on my form on the date field. I learned that process in institute but now forget the process.. Tell me the process and share the calender and standard file.
View 4 Replies View Relatedi need to be increasing the sequence no by 1 for every calender date.For example lets say if i receive 5 dumps of data for 24/09/2013 it should be as below. For next day the 25th the sequence no should again begin with 1.
24/09/2013 1
24/09/2013 2
24/09/2013 3
24/09/2013 4
24/09/2013 5
25/09/2013 1
I am new to the Oracle forms,i want to attach a calender to my form. I followed the below process:
--> I have attached the LOV&Record Group of the item for which the calender is attached as ENABLE_LIST_LAMP LOV which is included in the TEMPLATE.fmb
--> Set the validate from list to 'NO' in the property palette
--> Then after in the trigger KEY_LISTVAL,wrote the code
calendar.show;
while compile the form i got an error component 'SHOW' must be declared
How to set date persian to georgian calender.
View 1 Replies View RelatedI want to find the row with invalid day, month which are not matching with calendar day and month. Also the program should capture the data if the year <1900
with xx as
(select 101 as ID, '24/05/1899' as create_date from dual
union all
select 101, '32/03/2012' from dual
union all
select 102 ,'30/02/2012' from dual
union all
select 101 , '29/02/2013' from dual
[code]...
i have changed date's format and the calendar type in sqlplus through the following command so the date's format and the calender type both changed successfully and work, but in oracle form the they haven't changed.
alter session set nls_calendar='persian';
ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD';
ALTER SYSTEM SET NLS_DATE_FORMAT='YYYY/MM/DD' SCOPE=SPFILE;
Note: i know session would change the format temporally but i want to change it permanently so i tried alter_system but still no result
I need to block the weekends in Date Picker item. It must appear disabled.
View 1 Replies View RelatedI am using Apex 3.2
I have a field on my form called P4_START..It has a format mask of DD.MM.YYYY HH24 MI and a default value of TO_CHAR(SYSDATE, 'DD.MM.YYYY HH24:MI').
I need to create a validation which fires on save, to ensure the user is inputting a date and time
in my application I have several pages with the item of date. How to ensure that all items had the same date for all pages and can be set on each page ?.
Application Express: 4.1.0.00.32
DB: Version 10.2.0.4.0
Apex 3.2 I have a field called P14_START_DATE.The display as type is Date Picker (DD.MM.YYYY). Now if the user uses the pop up calendar, the field is populated with eg 07.12.2013. I have 2 standard validations, not null and item specified is a valid date. If the user decides to type in the date, they can use a different format, eg 07/12/2013, which I do not want to happen.How can I validate the field, so they get an error if they do not use format dd.mm.yyyy.
View 2 Replies View RelatedI'm using Apex 4.2.1 against Oracle 11gR2 and mod_plsql.create a date picker item that allows users to select seconds as well as hours and minutes.
I have searched this Forum and see that others have asked this question. The answers have all been "No". However, I've seen no such question since version 4.1 has been released, and so, am hoping there now is a way to do this.
I have adjusted the Date Format field to be "DD-Mon-YYYY HH24:MI:SS", both under the date picker item itself as well as under the "Global" parameters section of my application. All to no avail. The date picker shows only hours and minutes for the time portion.
How to validate a date in column section?
View 1 Replies View Relatedv: Apex 4.2
I have Dynamic report and column say some_date column and data can be in the columun (01-JAN-13) OR (01-JAN-13,04-JAN-13), (01-JAN-13,04-JAN-13,10-JAN-13) so on.
in actual table column some_date is date field but in report as above (string) because using RTRIM(some_date, ',') some_date within the select MODEL clause.
my problem is when run the report and select filter from action menu then it doesn't give option such as < , > or so on because of string but I want it should give <, <=, >, >= operators too as date column.
My environment settings:
Oracle Database 11.2.0.3.0 64 bits
Weblogic 10.3.5
APEX 4.2.2.00.11
When I try to access the development environment of the apex or any other screen, this error occurs intermittently.These errors (ORA-01821: date format not recognized) and (ORA-02063: preceding line from) are related to existing dblink's.
Parameters from apex database:
SQL> select * from nls_instance_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_SORT SPANISH
NLS_DATE_LANGUAGE AMERICAN
[code]....
Parameters from dblink database:
SQL> SELECT * from NLS_instance_PARAMETERS;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_SORT SPANISH
NLS_DATE_LANGUAGE
[code]....
I have an IR report and want to add another column such as complete_date. I want to add as a link so when user click it then should display the popup window or javascript popup for date selection. i don't want to use apex_item.date_popup or apex_item.date_popup2. On date selection popup user can choose only two dates such as yesterday or today all other date should be disabled?
View 2 Replies View RelatedAs all of you know, In the Apex, when you create a form with report in the page, you are able to insert and edit data. But when you edit the data, the data will be modified in the same row. In other word, you loose the old data.
What I need to do is: I have revised_num field and production_date field. I want to create a form with report and insert and edit data as is in the apex and insert 0 to the revised num until production date is null. But when production date is not null, then from that point, I want to insert data to another row and modify revised num to 1. and I want the revised num be incremented by 1 each time the user modifies the data after the production date is not null.I don't know where I should start.
I have a table in which I extract the year and the month and both in combination (from a date type). This is needed to summarize for example the year in a chart.
I need the combination of month and year because people could do a query which switches through years. For expample: From 02.2012 to 03.2013.My problem is I dont know how to tell anychart to sort the dates. I have already tried:
to_number(to_char(testdate,'YYYY')) as Year,
to_number(to_char(testdate,'YYYY'))||to_number(to_char(testdate,'MM')) as MonthyearApex now sorts:
20121,201212,20122
I would like that apex realizes to order:
1.2012,2.2012,3.2012 .........01.2013,02.2013.03.2013
The report itself has now four date relating collums:
1) Date (Type Date)
2) Year (Type Number)
3) Month (Type Number)
4) Monthyear (Type varchar)
In a detail tabular form I am referencing a date picker field from the master form as default value.This is the situation in the detail form:
TABULAR FORM
Column Name: FECHAREGISTRO -- the field's name in the detail tabular form
Default Type: Item (application or page item name)
Default: P68_FECHAREGISTRO -- It's a field in the master form and also is Date Picker format
Reference Table Owner: SAMPEDRORIVEROS
Reference Table Name: BITACORAABOGADO
Reference Column Name: FECHAREGISTRO -- It's a date field in the database
At execution time I have the error:
report error:ORA-01790: expression must have same datatype as corresponding expression
I think it is because i must use to_date and to_char in order to change the datatype and i have tried using:
Default: to_date(to_char(:P68_FECHAREGISTRO,'DD-MON-YYYY'),'DD-MON-YYYY')
and in Default Type: PL/SQL Expression or Function but I get a different message at execution time:
report error: ORA-01722: invalid number.
I am using the cloud version of APEX for a college course. The database script I am trying to load has dates formatted in "DD-MON-RR" and I receive 'not a valid month' and 'a non-numeric character was found where a numeric was expected'. Is there a workaround in APEX for this? I'm trying to avoid changing thousands of lines of data.
View 4 Replies View Relatedi want to apply validation on date item. i have created some cases if any case would be fail then error shold be fire.How can i do this.
my code
DECLARE
F DATE;
T DATE;
BEGIN
SELECT TO_DATE(F_DATE),TO_DATE(T_DATE) INTO F,T FROM VENDOR_CONTRACT_MAS WHERE CONTRACT_ID=:P5_CONTRACT_ID
[code]...
I have an APEX Page , page no1 for person's details that got fields like name, Date of Birth. When user enters the details, it get saved. Now when we want to edit a person's details, we click on that person then it goes to next page, where we can change/details of the person.But when i tried to do that, i am getting Not a valid month error.. log message shows that it is coming from : Automatic Row Processing (DML)- an after SUBMIT process. Is there a way to avoid this error?I changed date formats for several different ways.
View 1 Replies View Relatedsteps to achieve this report I need a Date Column on top of the page Depending on the selected date, Result should be displayed below for e.g.
suppose i select a date as 14-aug-2013
Enter Report Date ___________________ ( Date Picker) Location Name Report Date Quantity valueXYS 14/08/2013 5000 1200000ABCD 14/08/2013 2000 24000-------------------------------------------------------------------------------------------------TOTAL 7000 1224000