add an hour to the date if

[ksolecki]

Hey,

I have problem with data, i need to add 2 h to the data with one condition like below:

if(WildMatch([action],'*moved to category*'),[time of action] +2/24, [time of action] ) as [time of action_2]

I tried several methods but they do not work:

// Timestamp((YourTimeStamp + 2/24))

// Timestamp((YourTimeStamp + Timestamp(MakeTime(5,30))),'DD/MM/YYYY hh.mm.ss')

// Date( [Field] + MakeTime( 5 )

// Timestamp#([Field])+ maketime( 02, 00, 00 )

// Timestamp#([Field])+ hour( '02:00:00' )

// [Field+ hour( '02:00:00' )

// TimeStamp([Field]+'02:00','DD/MM/YYYY hh:mm')

//Date(   Floor(   [Created Date] + 5/24 ) , 'YYYY-MM-DD')

Thx for help.