Hi All,
Can you help me to resolve my issue, please?
I need to do prompt with default value equal last 2 week excluding current week. Any idea how to assign last 2 weeks to default value?
Ive create 2 objects 1 week before and 2 week before. This objects taking todays date extracting number of current week and minus 2 or minus 3. But I dont know how to assign them to prompt.
Thanks in advance
KatieT 
(BOB member since 2008-07-15)
hi
welcome to BOB.
can you explain in detail.?
judia
judia (BOB member since 2008-06-24)
There is no direct way to assign a default value to a prompt
There are however ways to get around it.
Read this post
.
haider 
(BOB member since 2005-07-18)
Thanks 
My teamleader wants if I put as default value BCA
Where BCA= 2 last week without current week.
Also she want to put this BCA as default in prompt
Is it more clear now?
Thank’s for links to other topics. It is very usefull, but I’ve got a question:
How to include labels in table using UNION?
I’m using SQL as data source.
Thanks in advance
Katie
KatieT (BOB member since 2008-07-15)
Is your original question answered or still need something?
The other part looks to be totally new and its better to open a new post for that.
.
haider (BOB member since 2005-07-18)
(BOB member since 2008-05-12)