Date decrement help:where event_cd = 'APSCH' AND lot_event_logs.crt_dt LIKE '2019-05-06%' AND lots.resp_fclty_id != 8

Learn Academy Feedback
1

where event_cd = ‘APSCH’ AND
lot_event_logs.crt_dt LIKE ‘2019-05-06%’ AND
lots.resp_fclty_id != 8

Need help on date decrement (yesterday date ) I ran this query daily.

AdvThks.

2

Use the code below.

DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd")

1 Like
3

HI,

I need your help in doing a small project into RPA.
need to run querys, output need to save into excel.

could you please help me.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.