Date( ) vs Date#( ) ???

[#1]

Hi all,

Can anyone please explain me the Date() and Date#()functions???

What is the difference when using hash(#)??

Thanks and Regards,

Nilupa

[#2]

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

[#3 · Accepted solution]

Hi,

Thanks.......

we can use

Date(Datefield,'DD/MM/YYYY')

to format the date.... So why date# ?

Thanks and Regards,

Nilupa

[#4]

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

[#5]

Thanks