Rockape Registered User. Local time Today, 07:44 Joined Aug 24, 2007 Messages 271 Aug 4, 2008 #1 Hi, Can anyone explain the logic of this parameter? >=Format(Date(),"\1/mm/yy")
khawar AWF VIP Local time Today, 10:44 Joined Oct 28, 2006 Messages 870 Aug 4, 2008 #2 It shows the first of current month
Rockape Registered User. Local time Today, 07:44 Joined Aug 24, 2007 Messages 271 Aug 4, 2008 #3 hmm.... not quite certain. I know it should look at the first day of the month [ Date() ] and beyond. I'm not quite clear on the construct!!!
hmm.... not quite certain. I know it should look at the first day of the month [ Date() ] and beyond. I'm not quite clear on the construct!!!
khawar AWF VIP Local time Today, 10:44 Joined Oct 28, 2006 Messages 870 Aug 4, 2008 #4 date() means Today so its current month
Rockape Registered User. Local time Today, 07:44 Joined Aug 24, 2007 Messages 271 Aug 4, 2008 #5 Hi, thanks. But why format? and why is there a switch in the form of a \ ? and why is there quotation marks? regards
Hi, thanks. But why format? and why is there a switch in the form of a \ ? and why is there quotation marks? regards
khawar AWF VIP Local time Today, 10:44 Joined Oct 28, 2006 Messages 870 Aug 4, 2008 #6 Format is used to combine 1(first) with the month and year of today In short you are extracting month and year from todays date and using 1st with that month and year to get the first day of current month
Format is used to combine 1(first) with the month and year of today In short you are extracting month and year from todays date and using 1st with that month and year to get the first day of current month
Rockape Registered User. Local time Today, 07:44 Joined Aug 24, 2007 Messages 271 Aug 5, 2008 #7 Thanks, penny dropped. Thanks again.