Difference b/w date and date# with exp please....

Tue, 02 Apr 2013 11:52:27 GMT

Help me on this....

Re: Difference b/w date and date# with exp please....

kaushiknsolanki — Tue, 02 Apr 2013 11:57:11 GMT

Hi,

The Date function will convert the numbers into date format, you can also define the date format. Something like this.

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

If you dont define the format, it takes the default one i.e MM/DD/YYYY

Date# Function is used to convert the text into date.

Date#('13/03/2003','DD/MM/YYYY')

Here you need to define the format in which your text is. Like in above example I have used "DD/MM/YYYY" Cause the example date is that format.

Hope this is clear.

Regards,

Kaushik Solanki