Recent content by bta1322

Forgot to mension entering this in column on report as variable

Hi Date one 04/11/2011 05:20:55 Date two 05/11/2011 06:21:23 trying to deduct one from the other to give result in hours and mins Using Webi version XI Can anyone point me in the right direction - help appriciated

Hi Hilfy I have been playing with your formula and tried =If(FormatDate([Available for Dispatch];"HH:mm:ss"))>="16:00:00" Then RelativeDate([Available for Dispatch]; +1) This does seem to be giving me my required results Thank you for you patience Regards Brian

incidentally, the formula does work without the +1

Hi Hilfy It seems to be the "1" (without quotes) that is being highlighted as error Keep getting error :- The expression or sub-expression at position 95 in the '+' function uses an invalid data type. (WIS 10037) =If(FormatDate([Available for Dispatch];"HH:mm:ss") >= "16:00:00";[Available...

ok, i am a newbie ! how do i - 1. convert [Available for Dispatch] to a string prior to doing the comparison. 2.You want to make sure to use the format string that will left-pad the hour with a zero (0) if the time is less than 10:00.

This is the variable formula in both AVAILABLE DESPATCH and AVAILABLE TIME columns =If([Date Last Hold Removed (all Holds)])='01/01/3000' Then ([Call over (UK)]) ElseIf [Call over (UK)]<[Date Last Hold Removed (all Holds)] Then [Date Last Hold Removed (all Holds)] ElseIf ([Call over...

Hi Hilfy Convert available time to string? Is that format as a number? Tried to do that and go Format error. How do i format to string?

Hi Hifty Thought this looked good, however, getting Invalid indentifyer "TIME"

thanks hilfy for your support have followed suggestion, now got two colums, one formatted as date and the other as time. Column one -[Available to Despatch] (Date Format) Column two -[Available to despatch] (Time format) - i have named this column diffent to the other (called available time)...

Hi Can anyone help Trying to use the mod function in Business Objects (end user web intelligents) = mod([call-over date];1) but keep getting error callover date example - 04/4/2011 09:21:13 trying to sperate date and time into diffent columns as variables Help / direction appriciated...

Hi Can anyone help Trying to use the mod function in Business Objects (end user web intelligents) = mod([call-over date];1) but keep getting error callover date example - 04/4/2011 09:21:13 trying to sperate date and time into diffent columns as variables Help / direction appriciated...

Hi steve In the report, i was hoping to add a column with a variable (if this is the right terminology?) brian

Apologies for accidentally high-jacking a posted thread (Skip Vought) - Wondered why i did not see it displayed I am a newbie, end used in BO (webI). No sure of the terminology correct I want to add 3 days to a date and time, using the following criteria:- Examples: Adding 3 days Mon...

Hi - new user to WebI Trying to use mod function in BO =mod([Available for delivery];1) Keep getting error. The Avaialble for delivery" column contains, date and time, eg 09/02/11 17:57:12 Any help appriciated Brian