Datetime - 1 fails on First day of the month

[mkav9893]

Hi,

I am having an issue for several scheduled workflows that I am running. I append the date on the end of the filename, and I exclude the previous days file by specifying on the date, using ToNumber([DateTimeNow])-1. However, this fails on the first day of the month because it sees 20180800 rather than 20180731 (As seen in the attached screenshot). Is there a way to handle this to dynamically opt to the last day of the month?

[patrick_digan · Accepted solution]

@mkav9893 how about:

ToNumber(DateTimeAdd([DateTimeNow],-1,"days"))

EDIT strike that. what about:

DateTimeFormat(DateTimeAdd(DateTimeNow(),-1,"days"),"%Y%m%d")