What is the output format of the DateTimeFirstOfTheMonth function? Also is it possible to nest the functions below?
[Previous_Month] =
DateTimeFormat(DateTimeAdd(DateTimeFirstOfMonth(),-1,"months")"%Y%M")
Solved! Go to Solution.
DateTimeFormat(DateTimeAdd(DateTimeFirstOfMonth(),-1,"Months"),"%Y%m")
the M must be m.
M = Minutes
m = Month
Cheers,
Mark