Original or actual date calculation

[Anbumani]

Respected all,

I have scenario, where i need to create new Colum with Original break date.

I have 4coulm Colum Date (daily date will populate), name (multiple name), Value(0 and any thing not equal 0), comment ( anything 0 no break, anything apart from 0 Break) - this i have build already.

now i have to run the workflow daily which will show daily basis data (if we have break yesterday and we run the workflow today the break comment will but the date will be today date, but i need create one additional column  (Original break date) where it should have the initial break date.

please help. 

[griffinwelsh]

@Anbumani If you are always looking at one day prior's data you can use datetimeadd([Date],-1,"days") in a formula to create your new column. You can modify this as needed if you need to account for weekends/holidays ect.