This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
To add a default date for a date/time field in database configuration just
add "&SYSDATE&" for current date and time as Default Value. What if I want
to have the same functionality as SYSDATE+30 to add thirty days? I am
getting "BMXAA4144E - The date/time format is not valid." message. I've
tried the following combination so far with the same results:
&SYSDATE&+30
&SYSDATE&+&30&
(&SYSDATE&)+30
SYSDATE+30
My target is to set PR.REQUIREDATE to have this as default date/time.
Environment:
Maximo 7.1.1.5
2005 SQL Server
Websphere 6.1
Any suggestions is much appreciated.
Dennis
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
Hi Dennis,
Please find the details for dynamic query variables which you can use in Maximo :
:yes true
:no false
:&date& current date
:&datetime& current date/time
:&user& logged in user
:&personid& Person ID of the logged in
:&appname& Application name
:&mboname& Name of the current business object
:&ownername& Name of the owner business object
:<relationshipname>.<attrname> Value of an attribute of a related business object of the current business object
:&owner&.<attrname> Value of an attribute of the owner business object
:&owner&.<relationshipname>.<attrname> Value of an attribute of the related business object of the owner business object
:$old_<attrname> The initial value from the database of the attribute
Don't forget the colons.
Thanks,
Victor.
--- In MAXIMO@yahoogroups.com, dennis_belandres@... wrote:
>
> To add a default date for a date/time field in database configuration just
> add "&SYSDATE&" for current date and time as Default Value. What if I want
> to have the same functionality as SYSDATE+30 to add thirty days? I am
> getting "BMXAA4144E - The date/time format is not valid." message. I've
> tried the following combination so far with the same results:
>
> &SYSDATE&+30
> &SYSDATE&+&30&
> (&SYSDATE&)+30
> SYSDATE+30
>
> My target is to set PR.REQUIREDATE to have this as default date/time.
>
> Environment:
> Maximo 7.1.1.5
> 2005 SQL Server
> Websphere 6.1
>
> Any suggestions is much appreciated.
>
> Dennis
>
>
>
>
>
>
>
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents, including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
Hi Victor,
Thanks for taking the time with my predicament.
I tried the following
:&datetime& + 30
(:&datetime&) + 30
Same issue.
Regards,
Dennis
"Victor" <vikas17.j@gmail.com>
Sent by: MAXIMO@yahoogroups.com
10/11/2011 10:47 AM
Please respond to
MAXIMO@yahoogroups.com
To
MAXIMO@yahoogroups.com
cc
Subject
[MAXIMO List] Re: Default dates
Hi Dennis,
Please find the details for dynamic query variables which you can use in
Maximo :
:yes – true
:no – false
:&date& – current date
:&datetime& – current date/time
:&user& – logged in user
:&personid& – Person ID of the logged in
:&appname& – Application name
:&mboname& – Name of the current business object
:&ownername& – Name of the owner business object
:<relationshipname>.<attrname> – Value of an attribute of a related
business object of the current business object
:&owner&.<attrname> – Value of an attribute of the owner business object
:&owner&.<relationshipname>.<attrname> – Value of an attribute of the
related business object of the owner business object
:$old_<attrname> – The initial value from the database of the attribute
Don't forget the colons.
Thanks,
Victor.
--- In MAXIMO@yahoogroups.com, dennis_belandres@... wrote:
>
> To add a default date for a date/time field in database configuration
just
> add "&SYSDATE&" for current date and time as Default Value. What if I
want
> to have the same functionality as SYSDATE+30 to add thirty days? I am
> getting "BMXAA4144E - The date/time format is not valid." message. I've
> tried the following combination so far with the same results:
>
> &SYSDATE&+30
> &SYSDATE&+&30&
> (&SYSDATE&)+30
> SYSDATE+30
>
> My target is to set PR.REQUIREDATE to have this as default date/time.
>
> Environment:
> Maximo 7.1.1.5
> 2005 SQL Server
> Websphere 6.1
>
> Any suggestions is much appreciated.
>
> Dennis
>
>
>
>
>
>
>
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only
for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents,
including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
Hi Dennis,
For doing the calculated default, you will have to run an escalation action. You cannot put the calculated default value in database configuration i.e., :&Date& + 30 which is incorrect in database configuration but we can use this in Actions application and run escalation to update the values.
Hope this helps.
--- In MAXIMO@yahoogroups.com, dennis_belandres@... wrote:
>
> Hi Victor,
>
> Thanks for taking the time with my predicament.
> I tried the following
>
> :&datetime& + 30
> (:&datetime&) + 30
>
> Same issue.
>
> Regards,
>
> Dennis
>
>
>
>
> "Victor" <vikas17.j@...>
> Sent by: MAXIMO@yahoogroups.com
> 10/11/2011 10:47 AM
> Please respond to
> MAXIMO@yahoogroups.com
>
>
> To
> MAXIMO@yahoogroups.com
> cc
>
> Subject
> [MAXIMO List] Re: Default dates
>
>
>
>
>
>
>
> Hi Dennis,
>
> Please find the details for dynamic query variables which you can use in
> Maximo :
>
> :yes â" true
> :no â" false
> :&date& â" current date
> :&datetime& â" current date/time
> :&user& â" logged in user
> :&personid& â" Person ID of the logged in
> :&appname& â" Application name
> :&mboname& â" Name of the current business object
> :&ownername& â" Name of the owner business object
> :<relationshipname>.<attrname> â" Value of an attribute of a related
> business object of the current business object
> :&owner&.<attrname> â" Value of an attribute of the owner business object
> :&owner&.<relationshipname>.<attrname> â" Value of an attribute of the
> related business object of the owner business object
> :$old_<attrname> â" The initial value from the database of the attribute
>
> Don't forget the colons.
>
> Thanks,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, dennis_belandres@ wrote:
> >
> > To add a default date for a date/time field in database configuration
> just
> > add "&SYSDATE&" for current date and time as Default Value. What if I
> want
> > to have the same functionality as SYSDATE+30 to add thirty days? I am
> > getting "BMXAA4144E - The date/time format is not valid." message. I've
> > tried the following combination so far with the same results:
> >
> > &SYSDATE&+30
> > &SYSDATE&+&30&
> > (&SYSDATE&)+30
> > SYSDATE+30
> >
> > My target is to set PR.REQUIREDATE to have this as default date/time.
> >
> > Environment:
> > Maximo 7.1.1.5
> > 2005 SQL Server
> > Websphere 6.1
> >
> > Any suggestions is much appreciated.
> >
> > Dennis
> >
> >
> >
> >
> >
> >
> >
> >
> > The information contained in and transmitted with this Email may be
> > privileged, proprietary, confidential and protected from disclosure. No
> > privilege is hereby intended to be waived. This Email is intended only
> for
> > the person to whom it is addressed. If you are not the intended
> > recipient/addressee, any use of the Email and/or its contents,
> including,
> > but not limited to, dissemination, distribution or copying is strictly
> > prohibited and may be unlawful, and you must not take any action in
> > reliance on it. If you receive this Email in error, please immediately
> > notify the sender and delete the original message and any copies of it
> > from your computer system. We deny any liability for damages resulting
> > from the use of this Email by the unintended recipient, including the
> > recipient in error.
> >
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents, including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
>
Victor,
The reasoning behind this is that we are getting null information in the
PR.REQUIREDDATE when reordering items through Inventory reorder process.
We are integrating Maximo with an external systems and running the
reordering process bi-weekly, which creates around 40-100 PR's at any
given time. Having to manually enter dates hinders our goal of trying to
automate this process. I could run an escalation to do the task or update
the database through the back-end but if we can set a default information
in the initial PR creation that would cut off the extra steps.
There's got to be a way.
Regards,
Dennis
"Victor" <vikas17.j@gmail.com>
Sent by: MAXIMO@yahoogroups.com
10/11/2011 11:28 AM
Please respond to
MAXIMO@yahoogroups.com
To
MAXIMO@yahoogroups.com
cc
Subject
[MAXIMO List] Re: Default dates
Hi Dennis,
For doing the calculated default, you will have to run an escalation
action. You cannot put the calculated default value in database
configuration i.e., :&Date& + 30 which is incorrect in database
configuration but we can use this in Actions application and run
escalation to update the values.
Hope this helps.
--- In MAXIMO@yahoogroups.com, dennis_belandres@... wrote:
>
> Hi Victor,
>
> Thanks for taking the time with my predicament.
> I tried the following
>
> :&datetime& + 30
> (:&datetime&) + 30
>
> Same issue.
>
> Regards,
>
> Dennis
>
>
>
>
> "Victor" <vikas17.j@...>
> Sent by: MAXIMO@yahoogroups.com
> 10/11/2011 10:47 AM
> Please respond to
> MAXIMO@yahoogroups.com
>
>
> To
> MAXIMO@yahoogroups.com
> cc
>
> Subject
> [MAXIMO List] Re: Default dates
>
>
>
>
>
>
>
> Hi Dennis,
>
> Please find the details for dynamic query variables which you can use in
> Maximo :
>
> :yes â€" true
> :no â€" false
> :&date& â€" current date
> :&datetime& â€" current date/time
> :&user& â€" logged in user
> :&personid& â€" Person ID of the logged in
> :&appname& â€" Application name
> :&mboname& â€" Name of the current business object
> :&ownername& â€" Name of the owner business object
> :<relationshipname>.<attrname> â€" Value of an attribute of a related
> business object of the current business object
> :&owner&.<attrname> â€" Value of an attribute of the owner business
object
> :&owner&.<relationshipname>.<attrname> â€" Value of an attribute of the
> related business object of the owner business object
> :$old_<attrname> â€" The initial value from the database of the
attribute
>
> Don't forget the colons.
>
> Thanks,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, dennis_belandres@ wrote:
> >
> > To add a default date for a date/time field in database configuration
> just
> > add "&SYSDATE&" for current date and time as Default Value. What if I
> want
> > to have the same functionality as SYSDATE+30 to add thirty days? I am
> > getting "BMXAA4144E - The date/time format is not valid." message.
I've
> > tried the following combination so far with the same results:
> >
> > &SYSDATE&+30
> > &SYSDATE&+&30&
> > (&SYSDATE&)+30
> > SYSDATE+30
> >
> > My target is to set PR.REQUIREDATE to have this as default date/time.
> >
> > Environment:
> > Maximo 7.1.1.5
> > 2005 SQL Server
> > Websphere 6.1
> >
> > Any suggestions is much appreciated.
> >
> > Dennis
> >
> >
> >
> >
> >
> >
> >
> >
> > The information contained in and transmitted with this Email may be
> > privileged, proprietary, confidential and protected from disclosure.
No
> > privilege is hereby intended to be waived. This Email is intended only
> for
> > the person to whom it is addressed. If you are not the intended
> > recipient/addressee, any use of the Email and/or its contents,
> including,
> > but not limited to, dissemination, distribution or copying is strictly
> > prohibited and may be unlawful, and you must not take any action in
> > reliance on it. If you receive this Email in error, please immediately
> > notify the sender and delete the original message and any copies of it
> > from your computer system. We deny any liability for damages resulting
> > from the use of this Email by the unintended recipient, including the
> > recipient in error.
> >
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only
for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents,
including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
>
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
We had the same issue with re-order. Our solution was to extend the PR
class file and add the code there. It was the only way we could get the
date to populate out a week on PR's during auto-reorder. Doing it that
way, also covers you when you are duplicating req's as well..
Brian Swanson
Systems Analyst-Maximo
Information Technology
HermanMiller
From: dennis_belandres@denso-diam.com
To: MAXIMO@yahoogroups.com
Date: 10/11/2011 11:42 AM
Subject: Re: [MAXIMO List] Re: Default dates
Sent by: MAXIMO@yahoogroups.com
Victor,
The reasoning behind this is that we are getting null information in the
PR.REQUIREDDATE when reordering items through Inventory reorder process.
We are integrating Maximo with an external systems and running the
reordering process bi-weekly, which creates around 40-100 PR's at any
given time. Having to manually enter dates hinders our goal of trying to
automate this process. I could run an escalation to do the task or update
the database through the back-end but if we can set a default information
in the initial PR creation that would cut off the extra steps.
There's got to be a way.
Regards,
Dennis
"Victor" <vikas17.j@gmail.com>
Sent by: MAXIMO@yahoogroups.com
10/11/2011 11:28 AM
Please respond to
MAXIMO@yahoogroups.com
To
MAXIMO@yahoogroups.com
cc
Subject
[MAXIMO List] Re: Default dates
Hi Dennis,
For doing the calculated default, you will have to run an escalation
action. You cannot put the calculated default value in database
configuration i.e., :&Date& + 30 which is incorrect in database
configuration but we can use this in Actions application and run
escalation to update the values.
Hope this helps.
--- In MAXIMO@yahoogroups.com, dennis_belandres@... wrote:
>
> Hi Victor,
>
> Thanks for taking the time with my predicament.
> I tried the following
>
> :&datetime& + 30
> (:&datetime&) + 30
>
> Same issue.
>
> Regards,
>
> Dennis
>
>
>
>
> "Victor" <vikas17.j@...>
> Sent by: MAXIMO@yahoogroups.com
> 10/11/2011 10:47 AM
> Please respond to
> MAXIMO@yahoogroups.com
>
>
> To
> MAXIMO@yahoogroups.com
> cc
>
> Subject
> [MAXIMO List] Re: Default dates
>
>
>
>
>
>
>
> Hi Dennis,
>
> Please find the details for dynamic query variables which you can use in
> Maximo :
>
> :yes â?" true
> :no â?" false
> :&date& â?" current date
> :&datetime& â?" current date/time
> :&user& â?" logged in user
> :&personid& â?" Person ID of the logged in
> :&appname& â?" Application name
> :&mboname& â?" Name of the current business object
> :&ownername& â?" Name of the owner business object
> :<relationshipname>.<attrname> â?" Value of an attribute of a related
> business object of the current business object
> :&owner&.<attrname> â?" Value of an attribute of the owner business
object
> :&owner&.<relationshipname>.<attrname> â?" Value of an attribute of the
> related business object of the owner business object
> :$old_<attrname> â?" The initial value from the database of the
attribute
>
> Don't forget the colons.
>
> Thanks,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, dennis_belandres@ wrote:
> >
> > To add a default date for a date/time field in database configuration
> just
> > add "&SYSDATE&" for current date and time as Default Value. What if I
> want
> > to have the same functionality as SYSDATE+30 to add thirty days? I am
> > getting "BMXAA4144E - The date/time format is not valid." message.
I've
> > tried the following combination so far with the same results:
> >
> > &SYSDATE&+30
> > &SYSDATE&+&30&
> > (&SYSDATE&)+30
> > SYSDATE+30
> >
> > My target is to set PR.REQUIREDATE to have this as default date/time.
> >
> > Environment:
> > Maximo 7.1.1.5
> > 2005 SQL Server
> > Websphere 6.1
> >
> > Any suggestions is much appreciated.
> >
> > Dennis
> >
> >
> >
> >
> >
> >
> >
> >
> > The information contained in and transmitted with this Email may be
> > privileged, proprietary, confidential and protected from disclosure.
No
> > privilege is hereby intended to be waived. This Email is intended only
> for
> > the person to whom it is addressed. If you are not the intended
> > recipient/addressee, any use of the Email and/or its contents,
> including,
> > but not limited to, dissemination, distribution or copying is strictly
> > prohibited and may be unlawful, and you must not take any action in
> > reliance on it. If you receive this Email in error, please immediately
> > notify the sender and delete the original message and any copies of it
> > from your computer system. We deny any liability for damages resulting
> > from the use of this Email by the unintended recipient, including the
> > recipient in error.
> >
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only
for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents,
including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
>
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
Brian,
Haven't really done any java class customization but wouldn't hesitate to
try.
To tell you the truth, I have no idea where to start.
I do have a development box where I can test customizing, with your
guidance or at least some direction (or sample).
Thanks in advance,
Dennis
Brian Swanson <brian_swanson@hermanmiller.com>
Sent by: MAXIMO@yahoogroups.com
10/11/2011 11:49 AM
Please respond to
MAXIMO@yahoogroups.com
To
MAXIMO@yahoogroups.com
cc
Subject
Re: [MAXIMO List] Re: Default dates
We had the same issue with re-order. Our solution was to extend the PR
class file and add the code there. It was the only way we could get the
date to populate out a week on PR's during auto-reorder. Doing it that
way, also covers you when you are duplicating req's as well..
Brian Swanson
Systems Analyst-Maximo
Information Technology
HermanMiller
From: dennis_belandres@denso-diam.com
To: MAXIMO@yahoogroups.com
Date: 10/11/2011 11:42 AM
Subject: Re: [MAXIMO List] Re: Default dates
Sent by: MAXIMO@yahoogroups.com
Victor,
The reasoning behind this is that we are getting null information in the
PR.REQUIREDDATE when reordering items through Inventory reorder process.
We are integrating Maximo with an external systems and running the
reordering process bi-weekly, which creates around 40-100 PR's at any
given time. Having to manually enter dates hinders our goal of trying to
automate this process. I could run an escalation to do the task or update
the database through the back-end but if we can set a default information
in the initial PR creation that would cut off the extra steps.
There's got to be a way.
Regards,
Dennis
"Victor" <vikas17.j@gmail.com>
Sent by: MAXIMO@yahoogroups.com
10/11/2011 11:28 AM
Please respond to
MAXIMO@yahoogroups.com
To
MAXIMO@yahoogroups.com
cc
Subject
[MAXIMO List] Re: Default dates
Hi Dennis,
For doing the calculated default, you will have to run an escalation
action. You cannot put the calculated default value in database
configuration i.e., :&Date& + 30 which is incorrect in database
configuration but we can use this in Actions application and run
escalation to update the values.
Hope this helps.
--- In MAXIMO@yahoogroups.com, dennis_belandres@... wrote:
>
> Hi Victor,
>
> Thanks for taking the time with my predicament.
> I tried the following
>
> :&datetime& + 30
> (:&datetime&) + 30
>
> Same issue.
>
> Regards,
>
> Dennis
>
>
>
>
> "Victor" <vikas17.j@...>
> Sent by: MAXIMO@yahoogroups.com
> 10/11/2011 10:47 AM
> Please respond to
> MAXIMO@yahoogroups.com
>
>
> To
> MAXIMO@yahoogroups.com
> cc
>
> Subject
> [MAXIMO List] Re: Default dates
>
>
>
>
>
>
>
> Hi Dennis,
>
> Please find the details for dynamic query variables which you can use in
> Maximo :
>
> :yes â?" true
> :no â?" false
> :&date& â?" current date
> :&datetime& â?" current date/time
> :&user& â?" logged in user
> :&personid& â?" Person ID of the logged in
> :&appname& â?" Application name
> :&mboname& â?" Name of the current business object
> :&ownername& â?" Name of the owner business object
> :<relationshipname>.<attrname> â?" Value of an attribute of a related
> business object of the current business object
> :&owner&.<attrname> â?" Value of an attribute of the owner business
object
> :&owner&.<relationshipname>.<attrname> â?" Value of an attribute of the
> related business object of the owner business object
> :$old_<attrname> â?" The initial value from the database of the
attribute
>
> Don't forget the colons.
>
> Thanks,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, dennis_belandres@ wrote:
> >
> > To add a default date for a date/time field in database configuration
> just
> > add "&SYSDATE&" for current date and time as Default Value. What if I
> want
> > to have the same functionality as SYSDATE+30 to add thirty days? I am
> > getting "BMXAA4144E - The date/time format is not valid." message.
I've
> > tried the following combination so far with the same results:
> >
> > &SYSDATE&+30
> > &SYSDATE&+&30&
> > (&SYSDATE&)+30
> > SYSDATE+30
> >
> > My target is to set PR.REQUIREDATE to have this as default date/time.
> >
> > Environment:
> > Maximo 7.1.1.5
> > 2005 SQL Server
> > Websphere 6.1
> >
> > Any suggestions is much appreciated.
> >
> > Dennis
> >
> >
> >
> >
> >
> >
> >
> >
> > The information contained in and transmitted with this Email may be
> > privileged, proprietary, confidential and protected from disclosure.
No
> > privilege is hereby intended to be waived. This Email is intended only
> for
> > the person to whom it is addressed. If you are not the intended
> > recipient/addressee, any use of the Email and/or its contents,
> including,
> > but not limited to, dissemination, distribution or copying is strictly
> > prohibited and may be unlawful, and you must not take any action in
> > reliance on it. If you receive this Email in error, please immediately
> > notify the sender and delete the original message and any copies of it
> > from your computer system. We deny any liability for damages resulting
> > from the use of this Email by the unintended recipient, including the
> > recipient in error.
> >
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only
for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents,
including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
>
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
Hi,
Using 7.1.1.8 I have the following including the colon in the default field of database configuration for the follow up date of the PO
:&DATE&+14
That will put today's date plus 14 days in the follow up field of the PO.
You can put the calculation in the default field of database configuration.
Dave Bone
--- In MAXIMO@yahoogroups.com, dennis_belandres@... wrote:
>
> To add a default date for a date/time field in database configuration just
> add "&SYSDATE&" for current date and time as Default Value. What if I want
> to have the same functionality as SYSDATE+30 to add thirty days? I am
> getting "BMXAA4144E - The date/time format is not valid." message. I've
> tried the following combination so far with the same results:
>
> &SYSDATE&+30
> &SYSDATE&+&30&
> (&SYSDATE&)+30
> SYSDATE+30
>
> My target is to set PR.REQUIREDATE to have this as default date/time.
>
> Environment:
> Maximo 7.1.1.5
> 2005 SQL Server
> Websphere 6.1
>
> Any suggestions is much appreciated.
>
> Dennis
>
>
>
>
>
>
>
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents, including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
Hi Dave,
Tried ":&DATE&+30" as Default Value for PR.REQUIREDDATE and got
"BMXAA4144E - The date/time format is not valid" message when trying to
save changes.
We are on Maximo 7.1.1.5
Regards,
Dennis
"in2data" <in2data@yahoo.com>
Sent by: MAXIMO@yahoogroups.com
10/11/2011 12:20 PM
Please respond to
MAXIMO@yahoogroups.com
To
MAXIMO@yahoogroups.com
cc
Subject
[MAXIMO List] Re: Default dates
Hi,
Using 7.1.1.8 I have the following including the colon in the default
field of database configuration for the follow up date of the PO
:&DATE&+14
That will put today's date plus 14 days in the follow up field of the PO.
You can put the calculation in the default field of database
configuration.
Dave Bone
--- In MAXIMO@yahoogroups.com, dennis_belandres@... wrote:
>
> To add a default date for a date/time field in database configuration
just
> add "&SYSDATE&" for current date and time as Default Value. What if I
want
> to have the same functionality as SYSDATE+30 to add thirty days? I am
> getting "BMXAA4144E - The date/time format is not valid." message. I've
> tried the following combination so far with the same results:
>
> &SYSDATE&+30
> &SYSDATE&+&30&
> (&SYSDATE&)+30
> SYSDATE+30
>
> My target is to set PR.REQUIREDATE to have this as default date/time.
>
> Environment:
> Maximo 7.1.1.5
> 2005 SQL Server
> Websphere 6.1
>
> Any suggestions is much appreciated.
>
> Dennis
>
>
>
>
>
>
>
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only
for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents,
including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
The information contained in and transmitted with this Email may be
privileged, proprietary, confidential and protected from disclosure. No
privilege is hereby intended to be waived. This Email is intended only for
the person to whom it is addressed. If you are not the intended
recipient/addressee, any use of the Email and/or its contents, including,
but not limited to, dissemination, distribution or copying is strictly
prohibited and may be unlawful, and you must not take any action in
reliance on it. If you receive this Email in error, please immediately
notify the sender and delete the original message and any copies of it
from your computer system. We deny any liability for damages resulting
from the use of this Email by the unintended recipient, including the
recipient in error.
Hi,
Look at the Type for PR.REQUIREDDATE . In my sandbox system it has datetime.
Use:&DATETIME&+30 for the default value for a datetime field.
Or change the type to just date.
Hope that helps.
Dave Bone
--- In MAXIMO@yahoogroups.com, dennis_belandres@... wrote:
>
> Hi Dave,
>
> Tried ":&DATE&+30" as Default Value for PR.REQUIREDDATE and got
> "BMXAA4144E - The date/time format is not valid" message when trying to
> save changes.
>
> We are on Maximo 7.1.1.5
>
> Regards,
>
> Dennis
>
>
>
>
>
> "in2data" <in2data@...>
> Sent by: MAXIMO@yahoogroups.com
> 10/11/2011 12:20 PM
> Please respond to
> MAXIMO@yahoogroups.com
>
>
> To
> MAXIMO@yahoogroups.com
> cc
>
> Subject
> [MAXIMO List] Re: Default dates
>
>
>
>
>
>
>
> Hi,
>
> Using 7.1.1.8 I have the following including the colon in the default
> field of database configuration for the follow up date of the PO
>
> :&DATE&+14
>
> That will put today's date plus 14 days in the follow up field of the PO.
>
> You can put the calculation in the default field of database
> configuration.
>
> Dave Bone
>
> --- In MAXIMO@yahoogroups.com, dennis_belandres@ wrote:
> >
> > To add a default date for a date/time field in database configuration
> just
> > add "&SYSDATE&" for current date and time as Default Value. What if I
> want
> > to have the same functionality as SYSDATE+30 to add thirty days? I am
> > getting "BMXAA4144E - The date/time format is not valid." message. I've
> > tried the following combination so far with the same results:
> >
> > &SYSDATE&+30
> > &SYSDATE&+&30&
> > (&SYSDATE&)+30
> > SYSDATE+30
> >
> > My target is to set PR.REQUIREDATE to have this as default date/time.
> >
> > Environment:
> > Maximo 7.1.1.5
> > 2005 SQL Server
> > Websphere 6.1
> >
> > Any suggestions is much appreciated.
> >
> > Dennis
> >
> >
> >
> >
> >
> >
> >
> >
> > The information contained in and transmitted with this Email may be
> > privileged, proprietary, confidential and protected from disclosure. No
> > privilege is hereby intended to be waived. This Email is intended only
> for
> > the person to whom it is addressed. If you are not the intended
> > recipient/addressee, any use of the Email and/or its contents,
> including,
> > but not limited to, dissemination, distribution or copying is strictly
> > prohibited and may be unlawful, and you must not take any action in
> > reliance on it. If you receive this Email in error, please immediately
> > notify the sender and delete the original message and any copies of it
> > from your computer system. We deny any liability for damages resulting
> > from the use of this Email by the unintended recipient, including the
> > recipient in error.
> >
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
>
> The information contained in and transmitted with this Email may be
> privileged, proprietary, confidential and protected from disclosure. No
> privilege is hereby intended to be waived. This Email is intended only for
> the person to whom it is addressed. If you are not the intended
> recipient/addressee, any use of the Email and/or its contents, including,
> but not limited to, dissemination, distribution or copying is strictly
> prohibited and may be unlawful, and you must not take any action in
> reliance on it. If you receive this Email in error, please immediately
> notify the sender and delete the original message and any copies of it
> from your computer system. We deny any liability for damages resulting
> from the use of this Email by the unintended recipient, including the
> recipient in error.
>
>
>
>
>