Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
date(Transaction_Date - 320)
Load *, Date(Transaction_Date-320) as New_Date;
Load
Date(MakeDate(2012) + Ceil(Rand() * 365)) as Transaction_Date
AutoGenerate 1
Thank you both you are both correct
If you got what you were looking for, please close the thread by marking the correct answer