I need to subtract one day if the time is between 12AM and 2AM

[tdisalvo]

I have a Time field =IC_HistoryProducts[Time]

And a Date field= IC_HistoryProducts[TransactionDate]

What I need is to subtract 1 day from the date field if the time field is between 12AM~2AM

This is driving me nuts and could use some help

[Pulkit]

Hi,

Try

new column = IF([Timecolumn]>12:00AM,IF([Timecolumn]<2:00AM,DATEADD([datecolumn],-1,date),[datecolumn])

I am not sure if this is it so let me know if it works.

[jthomson · Accepted solution]

What does this do:

newcolumn = if(hour(IC_HistoryProducts[Time])<2, previousday(IC_HistoryProducts[TransactionDate]),IC_HistoryProducts[TransactionDate])