nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

366909_en-US

liliconcom

combine formula

Hi, could someone help me combine the 2 formulas below? The second one is simply minus the time of day part. Thank you.

----------------------------------------

New Column( "week start",

Numeric,

"Nominal",

Format( "m/d/y", 12 ),

Input Format( "m/d/y" ),

Formula(

If( Day Of Week( :WR_Date ) == 1,

(:WR_Date - In Days( Day Of Week( :WR_Date ) )) - In Days( 5 ),

(:WR_Date - In Days( Day Of Week( :WR_Date ) )) + In Days( 2 )

)

Set Selected

New Column( "Date[week start]",

Numeric,

"Nominal",

Format( "m/d/y", 12 ),

Input Format( "m/d/y" ),

Formula( :week start - Time Of Day( :week start ) ),

Set Selected

Scripting

Re: combine formula

I'm doing this quickly, but I think this would work:

New Column( "Date[week start]",
Numeric,
"Nominal",
Format( "m/d/y", 12 ),
Input Format( "m/d/y" ),
Formula( ( If( Day Of Week( :WR_Date ) == 1,
(:WR_Date - In Days( Day Of Week( :WR_Date ) )) - In Days( 5 ),
(:WR_Date - In Days( Day Of Week( :WR_Date ) )) + In Days( 2 )
) )
 - 
Time Of Day( ( If( Day Of Week( :WR_Date ) == 1,
(:WR_Date - In Days( Day Of Week( :WR_Date ) )) - In Days( 5 ),
(:WR_Date - In Days( Day Of Week( :WR_Date ) )) + In Days( 2 )
) ) )

All I did is copied the first formula (for "week start") and replaced every reference to "week start" in the second formula with the copied information.