Check for StringtoDate

ds_is_fun · Post by **ds_is_fun** » Mon Oct 15, 2007 11:07 am

How to check if StringtoDate converts successfully? The format being "yyyy-dd-mm". Thanks

DSguru2B · Post by **DSguru2B** » Mon Oct 15, 2007 12:16 pm

Well, apply StringToDate() function in a stage variable. If its unsuccessful, the stage variable will have all stars or astrixs. You can test for that. Thats one of the ways. I am sure there are other ways, just wait for our experts to drop by.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 15, 2007 4:44 pm

Try to insert the date into a column whose data type is Date - it should fail if your data value is not a valid date. For most database types, anyway.

ravi_tubati · Post by **ravi_tubati** » Tue Oct 16, 2007 3:26 am

ds_is_fun wrote:How to check if StringtoDate converts successfully? The format being "yyyy-dd-mm". Thanks

you can use datefromdayssince to add the days which u given date

balajisr · Post by **balajisr** » Tue Oct 16, 2007 3:54 am

Try this.

Code: Select all

IsValid('date',StringToDate(date,'%yyyy-%dd-%mm'))

DSXchange

Check for StringtoDate

Check for StringtoDate

Re: Check for StringtoDate