Home set date with current year as public const
Reply: 0

set date with current year as public const

user3644
1#
user3644 Published in September 20, 2018, 4:35 pm

i wish to set a date with fixed dd and mm but but current year, for eg 01/01/2018 or 31/01/2018, 05/08/2018 (in us dd and mm are reversed) and so on. hello guys, i wish to set a date with fixed dd and mm but but current year, for eg 01/01/2018 or 31/01/2018, 05/08/2018 (in us dd and mm are reversed) and so on. i know only number and string can be set as public const;

thereby i tried so far:

Public Const gen1 As Long = CLng(#1/1/year(date)#)

but is not working any tip please? thanks

share|improve this question

2 Answers 2

active oldest votes
up vote 1 down vote
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.29535 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO