|
-
Jan 18th, 2007, 06:10 AM
#1
Thread Starter
Hyperactive Member
[2005] Populate Date Field in Dataset
Hello,
I have a dataset that includes a couple of date fields (sDateFrom and sDateTo).
Id like to change the value of sDate from depending on what date it is in the dataset - so If sDateFrom is last month or earlier then I'd like sDateFrom to be the first of this current month.
For example :
If sDateFrom in dataset = 12/12/2006 then I'd like to change it to 01/01/2007
If sDateFrom in dataset = 07/01/2007 then I'd like to leave it as 07/01/2007
How can I do this ?
Thanks.
Last edited by Jonny1409; Jan 18th, 2007 at 06:32 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|