How do get a date 320 days before a date?

[mwallman]

Hi all,

I have the following date field:

Date(MakeDate(2012) + Ceil(Rand() * 365)) as Transaction_Date

How can I get a date 320 days before the Transaction_Date above? This would be a new field in the script

[Colin-Albert]

date(Transaction_Date - 320)

[MK_QSL]

Load *, Date(Transaction_Date-320) as New_Date;

Load

Date(MakeDate(2012) + Ceil(Rand() * 365)) as Transaction_Date

AutoGenerate 1

[mwallman]

Thank you both you are both correct

[sunny_talwar]

If you got what you were looking for, please close the thread by marking the correct answer

Qlik Community Tip: Marking Replies as Correct or Helpful