Previous Date Using Update Raw XML

Hi,

Can Someone help me to get the Previous date XML code. I have a radio button as Latest date, when I run the macro it should give me the result of current - 1 (previous date) data or max date data.

Thanks in Advance

Macros

Interface Tools

Accepted answers

BrandonB

DateTimeNow() can return the current date in a formula tool

DateTimeAdd(DateTimeNow(),-1,"days") will return yesterday dynamically. This formula can be applied to your max date as well if you want to figure out what one day before the last date is.

All comments

BrandonB

DateTimeNow() can return the current date in a formula tool

DateTimeAdd(DateTimeNow(),-1,"days") will return yesterday dynamically. This formula can be applied to your max date as well if you want to figure out what one day before the last date is.

sharduldolas1

Thanks BrandonB

it works.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335