Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Can anyone please explain me the Date() and Date#()functions???
What is the difference when using hash(#)??
Thanks and Regards,
Nilupa
Hi,
Thanks.......
we can use
Date(Datefield,'DD/MM/YYYY')
to format the date.... So why date# ?
Thanks and Regards,
Nilupa
Hi,
Date() is used to extract the date from your time stamp.
Ex1:
Let consdider date field as 06:10:2010 09:55:34,when you using this date() it will give your date field as 06:10:2010
Then Date#() is formatting funtion
Let consider your date field as 2010:10:06,when you use date#(date_field,'DD-MM-YYYY') it will give you result as 06:10:2010
Thanks & Regards
Jai
Hi,
Thanks.......
we can use
Date(Datefield,'DD/MM/YYYY')
to format the date.... So why date# ?
Thanks and Regards,
Nilupa
Hi,
Date# is used when value is not in Date format.
Many times values are like 23645. To convert it in equivalent Date format,
we use Date#.
When Date is in Date format itselft..say..DD/MM/YYYY and we want in DD-MMM-YY format,
we use Date only.
Hope this clarifies the difference.
Happy Thoughts
Thanks