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

[#1]

Help me on this....

[kaushiknsolanki]

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